Calculated field returning blank

[IoTWorld]

Hi everyone please help; 

I have this SQL in a calculated field; I want to return a value for this field from a cascading field if a certain question is answered yes in a  checked field.

IsNull(CASE

WHEN [@cbParamVirtual18] = 'Yes' THEN [@field:Employee_Payslips_Earning_1_Value]
 ELSE 0
END,0)

 

Anyone know what could be the reason I am getting calculation error or a blank field?

[CoopperBackpack]

Hello @IoTWorld,

If I understand you correctly the [@cbParamVirtual18] field is the Virtual field that is set to the Checkbox form element.

If so, please use single quotes to wrap the  [@cbParamVirtual18] field.  When the value in the Virtual field is a Text, always wrap the Virtual field in single quotes.

Also, double-check what value you have in the "Value when checked" field to compare with it.

Please test this formula:

CASE WHEN '[@cbParamVirtual18]' = 'Yes'
THEN [@field:Employee_Payslips_Earning_1_Value]
ELSE 0
END

Hope this helps. 

[Barbie]

Hello @IoTWorld you can also check this response. It is another approach for this workflow: 

 

 

[cheonsa]

Here is also an article that has a list of functions available for Calculated Value, Calculated Field, Aggregations and Formula Field.

https://howto.caspio.com/function-reference/