Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be like this?
If ( CR-DR>=0,CR-DR) as Quantity
Okay, please let me know the expected output from your attached excel file and also the formula that you are using.
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).