8 Replies Latest reply on Dec 4, 2017 7:49 AM by Renu Arjun

    ZN

    Renu Arjun

      Hi,

      I have been reading through prior posts trying to better understand how to apply the ZN function. I would prefer to use this instead of the other options (ISNULL or IFNULL) if possible. I am able to apply the ZN function ZN([Measure]).

       

      However, when I used it in a longer calculation, it does not seem to work. I have copied my formula below. I have not attached the workbook because I am still trying to figure out how to do so without sharing sensitive information.

       

      IF (([Version]=14 or [Version]=5) AND [Clasification]='INCOME')

      AND [Record_Date]=[Choose Month]

      THEN ZN([Budget])/[UF-Budgeted Rate]*-1

      ELSEIF (([Version]=14 or [Version]=5) AND [Clasification]='EXPENSES')

      AND [Record_Date]=[Choose Month]

      THEN ZN([Budget])/[UF-Budgeted Rate]*-1

      END

       

      Thanks,

      Renu