4 Replies Latest reply on Jun 29, 2018 9:13 AM by ALOK KUMAR SACHAN

Create a Yes/No field based on value

Megha Bhatnagar Jun 29, 2018 8:53 AM

I want to create a field that checks for every DMA if the value of store is 0 I want to display N and if it is > 0 the display Y.

I tried to create a calculated field with the following formula but IF COUNT([Store]) = 0 THEN 'N' ELSE 'Y' END, it does not give me the correct result.

I am attaching a sample workbook for reference.

stores-mock.twbx 39.2 KB

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
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
3. Re: Create a Yes/No field based on value

Don Wise Jun 29, 2018 8:59 AM (in response to Megha Bhatnagar)

Hi 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

1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
4. Re: Create a Yes/No field based on value

ALOK KUMAR SACHAN Jun 29, 2018 9:13 AM (in response to Megha Bhatnagar)

Hi Madhu
you can use Below Calculation for your problem (Hence all the above calculation are also Perfectly correct but if the data is in -ve then it will not work)

So as per your query word to word.. you can use below formula

(IF
[Store] = 0 THEN 'N'
ELSEIF
[Store] > 0 THEN 'Y'
END)

Thanks
Alok
Like Show 0 Likes(0)

Actions