Question Re: Percentaje functions in Technology Q&A

Percentaje functions

Former Member — Mon, 21 Jan 2008 03:24:18 GMT

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

Re: Percentaje functions

Former Member — Mon, 21 Jan 2008 03:51:27 GMT

Could you xplain me with an example of Values..??So I can give u some ideas.U try using the FORMULA KF to calculate the %.After calculation %,based on which u need calculate AVG????

thnx

Re: Percentaje functions

Former Member — Mon, 21 Jan 2008 03:54:03 GMT

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.

Re: Percentaje functions

Former Member — Tue, 22 Jan 2008 23:58:06 GMT

Thanks,

Mónica