sqlcurious
asked on
need to modify a select statement
Hi experts,
I need to modify the following case statement:
CASE WHEN AVG(I.Invoice_Amt)>MAX(cus t.Approval _Limit) THEN 0.75*(MAX(I.Invoice_Amt)) ELSE MAX(cust.Approval_Limit) END AS RecApprovalLimit
At THEN 0.75*(MAX(I.Invoice_Amt)) - I should also make sure 0.75*(MAX(I.Invoice_Amt)) doesnot exceed 50000, how do I incorporate the logic here, pls help
I need to modify the following case statement:
CASE WHEN AVG(I.Invoice_Amt)>MAX(cus
At THEN 0.75*(MAX(I.Invoice_Amt)) - I should also make sure 0.75*(MAX(I.Invoice_Amt)) doesnot exceed 50000, how do I incorporate the logic here, pls help
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER