I need to do a simple compare on a calculation I have done and an existing field value.
Here is the Token Calculation:
FIXED(((%(RetrieveFieldValues_Reg Hours_All#[%(LaborRows_Iteration)]#)+(%(RetrieveFieldValues_OT Hours_All#[%(LaborRows_Iteration)]#)*1.50)+(%(RetrieveFieldValues_DT Hours_All#[%(LaborRows_Iteration)]#)*2.00))*%(RetrieveFieldValues_Labor Rate_All#[%(LaborRows_Iteration)]#)),2)
Where:
Reg_Hours = 5.00 OT Hours = 0.00 DT Hours = 0.00 Rate = 55.00 Result: 275.00
I need to Compare to an Amount field with the value:
275.00
When I run the workflow I get the message:
11/21/2018 2:42:04 PM Labor Calculator Invalid Numeric Value: Expression: FIXED(((%(RetrieveFieldValues_Reg Hours_All#[%(LaborRows_Iteration)]#)+(%(RetrieveFieldValues_OT Hours_All#[%(LaborRows_Iteration)]#)*1.50)+(%(RetrieveFieldValues_DT Hours_All#[%(LaborRows_Iteration)]#)*2.00))*%(RetrieveFieldValues_Labor Rate_All#[%(LaborRows_Iteration)]#)),2)
I have tried to run this without the FIXED(). But the Result Value returned is:
275.0000
And apparently that does not equal
275.00