Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Gurus,
Is it any way to calculate the relative % of the total for each line in a straight table?
For example:
Prices % Participation (the one I want to calculate)
Average Price 5 5
Price 1 4 80%
Price 2 10 200%
Price 3 1 20%
Price 4 5 100%
Thanks!!
Regards,
Jordi
u can give ur exp
sum( prices)
and go to number tab and chk show in %
or else in expression tab u will find relative option u can chk there
maybe (you didn´t uploaded your data or expressions)
sum(prices) / sum(total prices)
Check !
You can also use expression as
SUM(Value)/Avg({1}total Value)
What expression are you using.
Regards
Anand
You are using variable also
Ex:-
Let vAvg = 5
Dim:- Price
Expre:- (SUM(Value)/ $(vAvg))
Regards
Anand
Thank you! It solved my question!
Regards,
Jordi