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.




      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?