6 Replies Latest reply on Jul 22, 2018 9:51 PM by Ellen Yeung

    Find difference if record in previous year doesn't exist (not just data is null)

    Ellen Yeung

      Hello everyone,

       

      I've attached a dummy workbook.

       

      If there is no record for Netherlands in 2017 at all, not just null for a certain measure, how do I graph the difference in Sales $ if I want to assume that there was $0 Sales in 2017?  My formula for the Difference in Sales $ is: ZN(SUM([Sales $])) - LOOKUP(ZN(SUM([Sales $])), -1)

       

      missing bar.JPG

       

      When I display this in a text table, the difference appears but I want to be able to graph the difference.

      Thanks for your help!