Text Box how to add suppress when value is none ?

[paulyeo11]

Hi All

Mt expression work fine , it display 14 :-

=count({<Reason-={'-'}>}Reason)

When i set the dimension suppress when value is none.  The total become 9.

When i using the same expression for text box , it display 14 , how can i make it display 9 ?

Paul Yeo

[sunny_talwar]

May be this

=Count({<Reason = {"*"}>}Reason)

[paulyeo11]

Hi Sunny

Your expression display 3000 plus.

Paul Yeo

Director

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

[sasiparupudi1]

Maybe

count({<Reason-={"=Len (Trim (Reason))=0"}>}Reason)

[paulyeo11]

Hi SAS,

Thank you very much for your help.

I still not getting 9 and getting 3000+, enclosed My QVW.

Paul

[Chanty4u]

simply try this

=NullCount(value)

[Chanty4u]

=NullCount(Reason)

[paulyeo11]

Hi chanty

I get 0 value.

Paul

[PrashantSangle · Accepted solution]

Hi,

use below expression,

=count({<Reason-={'-'},StatusV={'Won'}>}Reason)

Regards,

[paulyeo11]

Hi Pras

Wow you got it right.

Thank

Paul