Need helping with MOD function where N1 and N2 are CASE WHEN ({transactionlines.transactionlinetype#display} = "Inventory Count : Count Quantity" THEN {quantity} ELSE END, {transactionlines.transactionlinetype#display} = "Inventory Count : Adjusted Quantity" THEN {quantity} ELSE END)
Dataset is Transaction. Associated fields below.