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

# Percentage of first value in comparative analysis

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 ?
• ###### Re: Percentage of first value in comparative analysis

Maybe this:

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

I wouldn't be surprised if it doesn't work though. In that case please post a example document with some sample data and what the outcome of the calculation should be.

• ###### Re: Percentage of first value in comparative analysis

Hi,

Go to Properties->Number tab->and select fixed to and Specify decimal places and click on percentage

but the problem in data then post your sample like wasswnaar  told