Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
Need help in the Text box object, the expression, as I trying to display if the "COD" has no value it should print "NIL".
But the following expression works but prints as "0", can you help me how to print as Nil if its 0
=If(Len(Trim([COD]=0)),Count({<[COD]={' '}>}[COD]),'Nil')
Regards
TRy like
=If(Len(Trim([COD])) = 0 ,Count({<[COD]={' '}>}[COD]),'Nil')
Regards
Anand
Hi Try this:
=If(len(Trim([COD]))>0,count([COD]),'Nil')
Regards
KC
Hi,
Thanks for your reply Anand Chouhan, but it still gives same result of 0 only.
Regards
Try with
=If(Len(Trim([COD])) >= 0 ,Count({<[COD]={' '}>}[COD]),'Nil')
Or
=If(Len(Trim([COD])) > 0 ,Count([COD]),'Nil')
Hi,
Try
Like
=Count(If(Len(Trim([COD]))=0,[COD]))
or
Count({<[COD]={"isnull(COD)"}>}[COD])
Regards
Replace ID with primary key from your table
=If(Len(Trim([COD]=0)),Count({<ID={'=Len(Trim([COD]))=0'}>}ID),'Nil')
Hi,
Try this,
=if(isnull(COD),'Nil', COD)
Hope it will help.
Apurva
Vincent,
in my view it should simply be,
if(COD='','NIL', COD) as CODValue
Does this help. It simply evaluates if COD is an empty string or not
Please mark this as answered and complete if this is helpful
Hi,
If(Len(Trim([COD])) = 0 ,'Nil') Or
Alt([COD], 'Nil')