I have a table like this
At Commission 2% it should take "5999" instead of "105999" , how to do that ?
could you make it little more clear because in the image i do see 2.0% but u have mentioned as 0.2%.so, do provide an sample qvw app
ya bhanu ,
Qlik Community Tip: How to Get Answers to Your Post
Try Something like this:
You can use this in Script or in Expression.
hi aviral ,
Txs for reply ,
But it taking all 2% =5999 form there it shoud be cumilative sum .
Retrieving data ...