5 Replies Latest reply on Nov 24, 2014 12:24 PM by Tom W

    Calculation for seeing the difference in revenue compared to previous year

    nani kumar

      Situation: I would like to analyze my customer’s data. I have customer names and there revenue contribution for the last 2yrs I want to create calculation field that shows the difference in revenue when compared to previous year.

      Ex:

      Customer Name                     Tot Rev, 2013                        Tot Rev,2014                      Difference in 2014 Revenue

      ABC                                           $100.00                              $80.00                                    $(20.00)

      I have tried using this in the calculation field: ZN(SUM([Total Revenue])) - LOOKUP(ZN(SUM([Total Revenue])), -1) but this is not giving me the result that I am expecting.

       

      Any help will be greatly appreciated.