If-Else condition for table column

[Anonymous]

Hi,

Can any one suggest on this issue. I have exchange field with values (YTD & Cross). Now i have to display a column in normal table based on Exchange selection. If Exchange is YTD then 'DLY_YTD_VAR_VAL' field else 'DLY_CRSS_VAR_VAL' field.

I wrote below condition in expression of column but it is not working.

=if ([Exchange]='Cross',DLY_CROSS_VAR_VAL,DLY_YTD_VAR_VAL)

[sunny_talwar]

May be there are extra spaces or upper case/lower case issue... try this

=If(Upper(Trim([Exchange])) = 'CROSS', DLY_CROSS_VAR_VAL, DLY_YTD_VAR_VAL)