If statement

[#1]

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'))) ,

[Anonymous]

try this:

if(ACCNUM  = '1US002' or HUB = 'CPT' , 'USC')

[ganeshreddy]

May be try this

if(ACCNUM  = '1US002', if( HUB = 'CPT' , 'USC','No Data'),'No Data') ,

[maxgro]

if(ACCNUM  = '1US002' and HUB = 'CPT' , 'USC', 'boh')

[sunny_talwar]

What are you seeing and what do you expect to see?

[effinty2112]

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