Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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)