AnsweredAssumed Answered

Calculation Not Working When > 9

Question asked by enyko on Feb 2, 2017
Latest reply on Feb 3, 2017 by wimdecorte

Sorry for the confusing title.

 

We have a calculation that always worked in the past. But this is the first time we need to multiply by 10 and notice it doesn't work. In short, we want to multiply hours worked by a rate ($250). Here is what we have;

 

If ( Additional DJ Hours < "3" ; 750 ; Additional DJ Hours * 250)

 

[which should mean, if the hours are less than 3, charge $750. Otherwise, take "Additional DJ Hours" and multiply that by $250]

 

Additional DJ Hours field information uses a value list which basically consists of numbers 0 - 20.

 

When we select anything above 9, it gives us $750.


What am I missing?

 

Thank you!

Outcomes