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:ValueMargin]
 ELSE 0
END,0)

 

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

[NailDyanC]

Hi, have you tried to use this formula:

IsNull(CASE

WHEN '[@cbParamVirtual18]' = 'Yes'

THEN [@field:ValueMargin]
 ELSE 0
END,0)

I hope that works. 

[Barbie]

Hello, 

To know more about calculations, you can refer to these articles: 

https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/

https://howto.caspio.com/datapages/datapage-components/calculated-values/

I hope this helps. 

 

- Barbie

[cheonsa]

For the list of formula available in Caspio, you may check this article: 
https://howto.caspio.com/function-reference/