7 Replies Latest reply: May 9, 2018 10:49 AM by Elizabeth Viso RSS

    Comparing Month Differences

    Elizabeth Viso

      Hello,

       

      I have data on various months and I need to be able to select two different months and get the percentage difference between the two. So for February, I have 43% and for March I have 50% so I need to see that the difference is 15.05% but I"m not sure how to do that. Currently to calculate the percentage per month I use:

       

      Count({<[UMHC SYSTEM]={"100%"},[EC-LS-EM]={'EC'}>}[UMHC SYSTEM])/Count({<[EC-LS-EM]= {'EC'}>}[UMHC SYSTEM])

       

       

      I tried adding Min  & MaxString but that's not working.

       

      Thank you!