Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try the option Fixed to with two decimals
what if you check mark for showing 'relative' value in the expression.
go for relative option in chart level
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
use this
Num(Sum(sales_QTY),'###,##0.00%')