How to calculate a relative %

[jorditorras]

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

[Chanty4u]

u can give ur exp 

sum( prices)

and go to number tab and chk  show in %

[Chanty4u]

or else in expression tab   u will find relative option u can chk there

[Clever_Anjos]

maybe (you didn´t uploaded your data or expressions)

sum(prices) / sum(total prices)

[MK_QSL · Accepted solution]

Check !

You can also use expression as

SUM(Value)/Avg({1}total Value)

[its_anandrjs]

What expression are you using.

Regards

Anand

[its_anandrjs]

You are using variable also

Ex:-

Let vAvg = 5

Dim:- Price

Expre:- (SUM(Value)/ $(vAvg))

Regards

Anand

[jorditorras]

Thank you! It solved my question!

Regards,

Jordi