Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Srinivas
Creator
Creator

Subtract quantity values based on transaction type

Hi Team,

I want to subtract the quantity values based on different type transaction, in final Qty i want to see only positive values.

Actually logic is whatever total CR values minus DR Values for the same i did CR-DR as Qty , in that Qty columns have the negative values bot i don't want see the negative value.

 

Thanks,

Reddy

Labels (3)
4 Replies
shiveshsingh
Master
Master

May be like this?

If ( CR-DR>=0,CR-DR) as Quantity

Srinivas
Creator
Creator
Author

If we write this expression we are getting the wrong out put.
shiveshsingh
Master
Master

Okay, please let me know the expected output from your attached excel file and also the formula that  you are using.

Vengatesh
Partner - Creator
Partner - Creator

What you are trying to do here Subract? or Difference Between?, 

If you want to calculate the difference you can use this If(CR>DR ,CR-DR, DR-CR).

You Know What To Do.