Condition Not working

[abhaysingh]

Hi guys,

I m writing very simple if condition and strange its not working,,pls suggest

if((GL_CC_Flag=1 and  (Cost_Center)= 'NA'  ), Cost_Center=19001,0) as TestCenter;

i want where if((GL_CC_Flag=1 and  (Cost_Center)= 'NA'  ), will true cost centre will feed as 19001

when i m doing below for testing its working means giving output 1 but in above giving output 0

if((GL_CC_Flag=1 and  (Cost_Center)= 'NA'  ), 1,0) as TestCenter;

pls suggest

[engishfaque]

Dear Abhay,

Kindly share your sample data as the condition can be make properly.

Kind regards,

Ishfaque Ahmed