We help IT Professionals succeed at work.

CASE WHEN NOT 0 then Calculate else dont calculate

doramail05
doramail05 asked
on
Medium Priority
317 Views
Last Modified: 2012-08-13
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)
Comment
Watch Question

got it already

Payment_Filter = (CASE WHEN tmems.fSrvMemBSAmt <> 0 THEN
(tmems.fSrvMemBSAmt - tmems.fSrvMemPacAmt)
ELSE
0
END)

Author

Commented:
solved oredi

Explore More ContentExplore courses, solutions, and other research materials related to this topic.