Advertisement
yitzyy

Untitled

Nov 15th, 2021
3,087
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CASE WHEN {shipdate} <= {today} THEN
  2. ({amount}-NVL({discountamount},0)/{quantity})*({quantity}-NVL({quantitycommitted},0)-NVL({quantityshiprecv},0)) ELSE 0 END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement