Displaying % in a table

[#1]

Hi - I am trying to display revenue as a % of total but for some reason the % option is not working for me. This issue seem to only exist in the second column, % Last 3 Month.

Here is the formula that i am using to calculate % last 3 month:

=SUM({<month_offset={[>=-1<0]}>}price)+SUM({<month_offset={[>=-2<0]}>}price)+SUM({<month_offset={[>=-3<0]}>}price)/1000

Please help!

Z

[Gysbert_Wassenaar]

Try the option Fixed to with two decimals  

[saurabh5]

what if you check mark for showing 'relative' value in the expression.

[#4]

go for relative option in chart level

[MarcoWedel]

Hi,

maybe this solution works for you:

LOAD *,
    Num(Number, '(DEC)') as NumberDec,
    Dual(Num(Number*100,'(DEC)')&' %',Number)as NumberDec%;
LOAD pow(10, (Rand()*20)-10) as Number
AutoGenerate 40;

hope this helps

regards

Marco

[Anonymous]

use this

Num(Sum(sales_QTY),'###,##0.00%')