PowerPlay Percentages

[monsky]

Hi Guys,

I'd like to know how to perform percentage the calculation in PowerPlay?

For each Pct column the calculation should be:

(PRD1/3590)*100, (PRD2/3590)*100 (Total/3590)*100

Note that 3590 is the overall total and is not a fixed amount.

PRD1 Pct PRD2 Pct Total Pct
0 900 % 120 % 1020 %
1 400 % 250 % 650 %
2 300 % 650 % 950 %
3 200 % 400 % 600 %
4 150 % 220 % 370 %

Total 1950 % 1640 % 3590 %

I tried using Percent but you need to input a fixed amount. Percent of base will only get the total of column. I'd like to add them as another column rather than using Explore, Show Values As, % of Layer Total so that I can see them simultaneously.

 

[drlex]

If it was only the percentage of one measure and it was possible to calculate the overall total of that measure in the transformer model source, one could add a measure which is the percentage of overall total.

soi la, soi carré