2 Replies Latest reply: Oct 7, 2013 5:18 AM by Amuthabharathi Subramanian RSS

    Percentage of first value in comparative analysis



      Ive got a number of parameters which change over a period of time

      I'm doing a comparative analysis piece which works well and can get this working fine using the following as an expression


      = sum({[Group A] * $}comp.Members)


      but what id like to do is visualise it as a percentage change from the first value in the selection.


      I have a date column surprisingly  'Date'


      so I think somewhere in the statement id need to use


      min ({$} Date)


      so my final percent calculation would be something like :-



      = (sum({[Group A] * $}comp.Members)    /   sum({[Group A] * min({$}Date) }comp.Members)) * 100



      but this is clearly wrong , any help guys ?