Need help in the text box

[#1]

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

[its_anandrjs]

TRy like

=If(Len(Trim([COD])) = 0 ,Count({<[COD]={' '}>}[COD]),'Nil')

Regards

Anand

[jyothish8807]

Hi Try this:

=If(len(Trim([COD]))>0,count([COD]),'Nil')

Regards

KC

[#4]

Hi,

Thanks for your reply Anand Chouhan, but it still gives same result of 0 only.

Regards

[its_anandrjs]

Try with

=If(Len(Trim([COD])) >= 0 ,Count({<[COD]={' '}>}[COD]),'Nil')

Or

=If(Len(Trim([COD])) > 0 ,Count([COD]),'Nil')

[PrashantSangle]

Hi,

Try

Like

=Count(If(Len(Trim([COD]))=0,[COD]))

or

Count({<[COD]={"isnull(COD)"}>}[COD])

Regards

[anbu1984]

Replace ID with primary key from your table

=If(Len(Trim([COD]=0)),Count({<ID={'=Len(Trim([COD]))=0'}>}ID),'Nil')

[#8]

Hi,

Try this,

=if(isnull(COD),'Nil', COD)

Hope it will help.

Apurva

[mjm]

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

[#10]

Hi,

If(Len(Trim([COD])) = 0 ,'Nil') Or

Alt([COD], 'Nil')