Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I put these 2 if statements in 1 if statement.
if(match(CATEGORY,'4','9','16','21','22')=0,'Trust_Non-Reccuring','Trust_Reccuring') as FEETYPE
if(ActualAccount <>0,'Trust Reccuring') as FEETYPE
Thanks in advance.
Like this?
if(match(CATEGORY,'4','9','16','21','22')=0,'Trust_Non-Reccuring',if(ActualAccount <>0,'Trust Reccuring') ) as FEETYPE
What's the value supposed to be if CATEGORY=4 and ActualAccount=0?
-Rob
not fully understand the logic of your inquiry, however you can combine and, or, and nested if, for example,
=
if(match(CATEGORY,'4','9','16','21','22')=0 or ActualAccount=0, 'Trust_Non-Reccuring',
if(match(CATEGORY,'4','9','16','21','22')=1 or ActualAccount <>0, 'Trust_Reccuring',
'???'))