Percentage calculation

[Former Member]

Hi Experts,

I've got a question.

I would like to calculate the percentage from the total in EPMREporting

How do I calculate this? (%Percent)

it should be ProductX/Total

Thanks.

Regards,

[Former Member]

Hi Pheno,

You can use formula for %Percent Column,

=Productx/VLOOKUP("TOTAL",TABLERANGE,3,FALSE)

[former_member186338]

VLOOKUP will affect the report performance...

No issues with second total on top:

Vadim

[former_member186338]

Please explain some details:

How do you select products for this report? Do you have parent product to be used instead of local member?

Vadim

[Former Member]

Hello,

Thanks for your answer.

It is base level.

[former_member186338]

It's better to use some hierarchy parent to get TOTAL!

If it's not possible you can create a line at the top (hidden) with the second local member to get the same total value. Then create a local member in the column to divide each line per first line value.

Vadim