% display in report

[Former Member]

There is a requirement

(1- ((Commitments - Shipments )/ Commitment ))* 100.User want to see the data as %. means in the cell user wants to see the "%" symbol...

Is there a way can we achive this....

In the Percentage Deviation (%) we can achive variation between two values whereas here we need to subract the Percentage Deviation (%) value from 100..in that case I am not getting the % symbol in the report....

Thanks for ur help..

Raman

[Former Member]

(1- ((Commitments - Shipments )/ Commitment )) put just this formula in a new column and hide it and use the same in the next column with formula using a percentile function/

[Former Member]

percentile function with what ?

[Former Member]

<b>%GT 'formula'</b>, that would give you the % share of the formula in the overall result on a scale of 100%....

or try %CT

[Former Member]

1. Create a formula (1 - ((Commitment - Shipments) )

2. Hide the above formula

3. Create another formula: No. 1 Percentage share in Functions by Commitment.

that will do it.

thanks.

Wodn