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

    Calculation help required on  pervious value

    sreekanth.upputuri

      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 !!