Facing a problem to show a calcualtion in % format in text area

[#1]

Hi guys,

this is the calculation which i am doing to calculate sales vs target

(($(YtdNetSalesGoldDetailGrossWeight)-$(YtdNetSalesGoldDetailStoneWeight))/($(YtdTotalGOldWt)*$(AvgCurYear)))

$(YtdNetSalesGoldDetailGrossWeight)-$(YtdNetSalesGoldDetailStoneWeight))=4226231.30

$(YtdTotalGOldWt)=706.033

$(AvgCurYear)=96

I wan to show the ouput in text area like this format 61.03% but i am getting 6103.33 output

Pls help me all

Thanks in advance

[Anonymous · Accepted solution]

in a atable you can define the number Format in the number tab

in a textobject you Need to Format the dataformat

like num(your Expression,'#.##0,0%')

if the number is to hight you Need to divide by 100

[MK_QSL]

=Num(($(YtdNetSalesGoldDetailGrossWeight)-$(YtdNetSalesGoldDetailStoneWeight))/($(YtdTotalGOldWt) * $(AvgCurYear)),'#0.0%')

[Frank_Hartmann]

try

=num(frac(expression),'##.###,##%')

[#5]

i followed your answer and getting 6130.00 answer

but when i divided by 100 then i got 0.613099 as answer

[#6]

6130.99 as answer

[Frank_Hartmann]

try

=num(frac(expression),'##,###.##%')

or set in script:

SET ThousandSep='.';

SET DecimalSep=',';

and use:

=num(frac(expression),'##.###,##%')

[#8]

i need to get 61.30% as answer

[kkkumar82]

Is it possible to share a sample app by reducing some of the data

[gopi_pattepuram]

try this

=num((($(YtdNetSalesGoldDetailGrossWeight)-$(YtdNetSalesGoldDetailStoneWeight))/($(YtdTotalGOldWt)*$(AvgCurYear)))/100,'#,##0.00%')