doramail05
asked on
CASE WHEN NOT 0 then Calculate else dont calculate
trying to calculate a Payment_Filter field but some syntax occur,
logic : when tmems.fsrvmembsamt is not 0 then calculate, else dont calculate or set payment filter to 0
(CASE WHEN tmems.fSrvMemBSAmt <> 0 THEN
(tmems.fSrvMemBSAmt - tmems.fSrvMemPacAmt) as Payment_Filter
ELSE
Payment_Filter = 0
END)
logic : when tmems.fsrvmembsamt is not 0 then calculate, else dont calculate or set payment filter to 0
(CASE WHEN tmems.fSrvMemBSAmt <> 0 THEN
(tmems.fSrvMemBSAmt - tmems.fSrvMemPacAmt) as Payment_Filter
ELSE
Payment_Filter = 0
END)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER