November 3, 2011 at 8:05 am
Hi,
I have a requirement to add trade_Linked column in the report,for this column i need to write an expression Display if legal is Trade-Linked (Y/N).
how to write the expression in that particular column for example:=iif(thiscoulmn.this =y or n) like this we have to write,can anyone correct the expression?
it seems to be in the report : trade_Linked or trade_Linked
Y N
November 3, 2011 at 11:07 am
You would write this as
=IIF(thiscolumn.this = "Y",Put what you want to happen when the expression is true here, put what you want to happen when expression is false here)
November 3, 2011 at 11:09 am
You could also use a SWITCH
SWITCH(thiscolumn.this = "Y",what happens when it is Y,
thiscolumn.this = "N", what happens when it is N)
November 3, 2011 at 11:20 am
can i use this either of teh expression
=iif(Trd_linked()=0,N,Y) or =iif(fields!Trd_Linked.value =0,"N","Y")
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply