I think you may want the following instead:

IF [Store] = 0 THEN 'N' ELSE 'Y' END

Hi Megha,

    Change your calculation to:

IF SUM([Store]) = 0 THEN 'N' ELSE 'Y' END

Attached version 10.2 for your reference.

Regards,

Gerardo

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

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