It is possible to set checkmark condition using Calculated Value.
The field should be set as Calculated Value
The basic formula to set the condition is:
CASE
WHEN [@field:IntegerValue]=100 THEN 'X' ELSE 'Y'END
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(1as bit) ELSE CAST(0as bit)END
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
deemuss
It is possible to set checkmark condition using Calculated Value.
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:
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.