Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This if statement is not working.
I am not getting an error, but it is not returning the values I am expecting.
if(ACCNUM = '1US002', (if( HUB = 'CPT' , 'USC'))) ,
try this:
if(ACCNUM = '1US002' or HUB = 'CPT' , 'USC')
May be try this
if(ACCNUM = '1US002', if( HUB = 'CPT' , 'USC','No Data'),'No Data') ,
if(ACCNUM = '1US002' and HUB = 'CPT' , 'USC', 'boh')
What are you seeing and what do you expect to see?
Hi Robyn,
Your expression boils down to this:
if(CCNUM = '1US002' and HUB = 'CPT', 'USC')
which may be easier to read and figure out what's going on.
Cheers