Set condition to Yes/No field

[deemuss]

It is possible to set checkmark condition using Calculated Value.

1. The field should be set as Calculated Value
   
2. The basic formula to set the condition is:

   CASE 
   WHEN [@field:IntegerValue]=100 THEN 'X' ELSE 'Y'
   END

    

3. For Yes/No field, the boolean value us 1/0. However, to make it work properly, the field should receive BIT value. So, CAST function should be applied:
    

   CASE 
   WHEN [@field:IntegerValue]=100 THEN CAST(1 as bit) ELSE CAST(0 as bit)
   END

    

[Harbinger]

Perhaps you can give us a hint of what you're trying to get?

[Kimtran]

Thanks! it's helpful for newbie like me!

Kim