Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
=Num(($(YtdNetSalesGoldDetailGrossWeight)-$(YtdNetSalesGoldDetailStoneWeight))/($(YtdTotalGOldWt) * $(AvgCurYear)),'#0.0%')
try
=num(frac(expression),'##.###,##%')
i followed your answer and getting 6130.00 answer
but when i divided by 100 then i got 0.613099 as answer
6130.99 as answer
try
=num(frac(expression),'##,###.##%')
or set in script:
SET ThousandSep='.';
SET DecimalSep=',';
and use:
=num(frac(expression),'##.###,##%')
i need to get 61.30% as answer
Is it possible to share a sample app by reducing some of the data
try this
=num((($(YtdNetSalesGoldDetailGrossWeight)-$(YtdNetSalesGoldDetailStoneWeight))/($(YtdTotalGOldWt)*$(AvgCurYear)))/100,'#,##0.00%')