Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ? |
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.
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