This content has been marked as final.
Show 4 replies
-
1. Re: Create a Yes/No field based on value
Ken Flerlage Jun 29, 2018 8:59 AM (in response to Megha Bhatnagar)I think you may want the following instead:
IF [Store] = 0 THEN 'N' ELSE 'Y' END
-
2. Re: Create a Yes/No field based on value
Gerardo Varela Jun 29, 2018 8:59 AM (in response to Megha Bhatnagar)Hi Megha,
Change your calculation to:
IF SUM([Store]) = 0 THEN 'N' ELSE 'Y' END
Attached version 10.2 for your reference.
Regards,
Gerardo
-
stores-mock_v10.2_274493gv.twbx 34.4 KB
-
-
3. Re: Create a Yes/No field based on value
Don Wise Jun 29, 2018 8:59 AM (in response to Megha Bhatnagar)1 of 1 people found this helpfulHi Megha,
Just change your calculation from COUNT to SUM and it will work. If this is correct, please mark this response as such - thx, Don
-
4. Re: Create a Yes/No field based on value
ALOK KUMAR SACHAN Jun 29, 2018 9:13 AM (in response to Megha Bhatnagar)