Scripting in back end

[#1]

hi QVs,

I have a table like this

At Commission 2% it should take "5999" instead of "105999" , how to do that ?

-lohi

[#2]

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

[#3]

ya bhanu ,

At Commission 2% it should take "5999" instead of "105999" , how to do that ?

-lohi

[tresesco]

QlikCommunity Tip: How to get answers to your post?

[aveeeeeee7en]

Hi

Try Something like this:

If(Commission='2%','5999',CumulativeSum)

You can use this in Script or in Expression.

Regards

Aviral Nag

[#6]

hi aviral ,

Txs for reply ,

But it taking all 2% =5999 form there it shoud be cumilative sum .