Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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





11 Replies
sunny_talwar

It is strange that dividing by 6130/100 gave you 0.613099. How about dividing it by 10 since it seems to have doubled on its own. Does 6130/10 give you 61.30?

Not applicable
Author

Thanks for reply gopi.pattepuram same thing done ..got the answer