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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2016-07-19 04:48 AM

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





1,416 Views
0 Likes
11 Replies
sunny_talwar
MVP
MVP
‎2016-07-19 06:05 AM

In response to

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?

237 Views
0 Likes
Not applicable
‎2016-07-19 08:31 AM
Author

In response to gopi_pattepuram

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

237 Views