Integration Center - Calculated Fields

[vtamil]

Dear Experts, I am trying to build a column using calculation fields.

Band - 11, 5, 7 & 9 require N

Band - 1, 2,3,4,6,8,9,10,12,13 require Y

I am using IF/THEN/ELSE condition to build calculation. But report is NOT allowing to use more than 3 conditions to bring N value. Any suggestions would be really helpful

[Suresh_Jain1]

Hi Tamiz,

I did not use IF/Then/Else condition but I could able to use concatenate function for more than 3 columns and two fix column. In short total 6 columns are used in one condition and its working fine.

Please share the screen print of the condition.