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

      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.