13 Replies Latest reply on Sep 20, 2012 11:36 PM by sreekanth.upputuri

    Calculation help required on  pervious value


      Hi All,


      I need some calculation help on my workbook


      I have one measure objects name has like  “count “  on top of this one I have created two other calculated fields like below


      Percentage count” (SUM([COUNT]) / TOTAL(SUM([COUNT]))*100)

      “Delta%” ((PREVIOUS_VALUE([Percentage Count] )- [Percentage Count])*100)


      When I use this objects  in workbook the “Delta%” calculation are not working properly

      For example  week 36 percentage count minus week 35 percentage count (36-33 = 3 ) like that it has to come but mine will come  0

      Can you please see the attached screen short

      Calculation help .png


      Advanced Thanks for your great Help !!