Calculated value field - multiple conditions, calculation error

[Ras2019]

Hi,

I have made a few conditions in a CASE statement in a Calculated value field in a submission form. The first part of the case statement works fine, but when the conditions ''in red'' is changed, a calculation error is stated for the last formular. The field [@field:STF] is showing in the form and contain value and is exact as other fields. I have a feeling the whole syntax is wrong when i have multiple conditions.

I really appreciate if anyone have suggestions to correct the CASE statement (or if you believe the statement is correct as is)

CASE

WHEN [@field:Contract]="NO" AND [@field:Acceptance]= "YES" AND [@field:Terms]="F1"

THEN 

([@field:Rate]+[@field:HAND]*[@field:No_Of_Units])

WHEN [@field:Contract]="NO" AND [@field:Acceptance]= "YES" AND [@field:Terms]="F2"

THEN

([@field:Rate]+[@field:HAND]+[@field:PAC]*[@field:No_Of_Units])

WHEN [@field:Contract]="NO" AND [@field:Acceptance]= "NO" AND [@field:Terms]="F1"

THEN 

([@field:Rate]+[@field:HAND]*[@field:No_Of_Units])

WHEN [@field:Contract]="NO" AND [@field:Acceptance]= "NO" AND [@field:Terms]="F2"

THEN

([@field:Rate]+[@field:HAND]+[@field:PAC]+[@field:STF]*[@field:No_Of_Units])

END

 

Sincerely

Ras

[Vitalikssssss]

Hi @Ras2019,

The syntax looks correct and should output some result if you have all fields populated with values.

Can you specify the Datatype of fields used in calculated value expression?

Thanks,

Vitalikssssss

[Ras2019]

Hi,

Thanks.. you led me to the solution.

It was the datatype in STF! I had to change it to number. Couldnt see the tree for the forest.

Thanks again.

Ras