Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CASE WHEN {shipdate} <= {today} THEN
- ({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