3 Replies Latest reply on Sep 29, 2016 10:30 AM by sam.hong.0

    How to use Sum Number of Records in a Percentage? Formula INCLUDED.

    sam.hong.0

      Hello,

       

      I have the following formula that works but gives me a Number (Decimal) result but I would like it to appear as a percentage and I think it has something to do with it using Number of Records.

       

      (ZN(SUM([Number of Records])) - LOOKUP(ZN(SUM([Number of Records])), -1)) / ABS(LOOKUP(ZN(SUM([Number of Records])), -1))

       

      This formula is used to calculate Year over Year change but I can't seem to get it so the result appears as a percentage.

       

      Any suggestions?

       

      Thanks!