Change the calculation based on the using a checkbox

[JustTrying]

Hello,

I appreciate any help on this.

I have a calculation that I want to perform normally but when a field with a check box is selected I want to round the number up. This is what I have come up with this, but it's not working. Am I working in the right direction?

CASE

WHEN [@cbParamVirtual2]!== "Y"

THEN Round(((([@field:width]*[@field:height])/144)*[@field:panes]),2))

ELSE (([@field:width]*[@field:height])/144)*[@field:panes]

END

 

[NailDyanC]

Hello, 

Can you try using this formula instead:

CASE

WHEN CAST('[@cbParamVirtual1]' AS BIT) != 1

THEN Round(((([@field:width]*[@field:height])/144)*[@field:panes]),2))

ELSE (([@field:width]*[@field:height])/144)*[@field:panes]

END

 

Try to convert your Virtual field as Bit. Also, make sure that the value is 1 in your virtual field:

[cheonsa]

Hello, 

Just to add in the previous response, the value of a Yes/No field is either 1 or 0. If you are going to use it in a Calculated value or calculated field, convert it first as Bit

CAST([@field:FIELDNAME] AS BIT)

Then, if you are using a virtual field as a checkbox, make sure that the value is 1 or 0 when checked.

 

Hope this helps!