2 Replies Latest reply: Sep 12, 2018 1:43 AM by Reynaldson Aceberos RSS

    Percentage calculation Help

    Mahitha M

      Hi Experts,


      Can any one please help me on below requirement.


      I have Two KPIs Current Month Amount and Previous Month Amount

      [CM Amount] =Count({<[Month Year]={$(=Max([Month Year]))}>}Sales)          Result : 32.68

      [PM Amount] =Count({<[Month Year]={$(=Max([Month Year])-1)}>}Sales)      Result : 27.31

      Please help me to write the expression for how much Amount Percentage increased in Current Month compared to Previous Month.


      Thanks in advance