See, we are subtracting two quantities and we want our result to be shown as 0 if the actual result is negative, the trick is very simple, look at this example:
( ( 'GR quantity' - 'PO quantity' ) > 0 ) * ( 'GR quantity' - 'PO quantity' )
The first block will evaluate to 1 when GR quantity is greater than PO quantity and to 0 when it's smaller, so the result will be something like:
GR quantity: 6
PO quantity: 4
(( 6 - 1) > 0) * (6 - 4) will turn into 1 (true) * (6 - 4) = 2
The other case:
GR quantity: 4
PO quantity: 7
(( 4 - 7) > 0) * (4 - 7) will turn into 0 (false) * (4 - 7) = 0
No comments:
Post a Comment