Percentaje functions

[Former Member]

Hi all!!

I have this requeriment.

Im displaying a report that have some characteristics for example: zone and material; I want to calcule the percentaje of participate of one of the key figures over the total; Im using the %GT, but now I want to calculate the percentaje of the subtotals; that each subtotal be a 100%, I tried with the function %CT, but It doesnt work.

Is anyway to do this?? this is because I need to calculate a weightened price average.

Thanks for the help

Greetings

Mónica

[Former Member · Accepted solution]

Create a Formula and just include your K.F in the Formula ( e.g. ='K.F' ).

Now goto Properties and make setting Calculate Single value as Normalize Sub-Totals .

Tick the checkbox Also Apply to Results and from drop down box select Calculate Along Rows.

One drawback of this is you will get 3 decimal places in teh percentage values since u r using Normalization and this setting bypasses the decimal setting that is done in the properties.

Hope this helps.

[Former Member · Accepted solution]

Thanks,

Mónica