• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 290
  • Last Modified:

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)
0
doramail05
Asked:
doramail05
  • 2
1 Solution
 
doramail05Author Commented:
got it already

Payment_Filter = (CASE WHEN tmems.fSrvMemBSAmt <> 0 THEN
(tmems.fSrvMemBSAmt - tmems.fSrvMemPacAmt)
ELSE
0
END)
0
 
doramail05Author Commented:
solved oredi
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now