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

    Percentage of first value in comparative analysis

    lee williams

      HI

       

      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 ?