Suppress When expression with text

[renjithpl]

Hi All,

Suppose this is an output in a straight table

ID	Sum(CurrSales)	Sum(PrevSales)	Growth
1	100	200	-50%
2	N/A	500	N/A
3	0	0	0%
4	0	N/A	N/A

I want to suppress the IDs with all Null values and also with N/A's

Since  I have text (N/A) in the expression, ID 4 still shows up after i checked "Suppress When Values is Null"

Any idea?

Renji

[sergio0592]

And if you try with :

sum({<ID={"=sum(CurrSales)>0"} > }   CurrSales)

sum({<ID={"=sum(PrevSales)>0"} > }   PrevSales)

[renjithpl]

I have a condition to show that,

if (isnull(CurrSales), 'N/A', sum({<ID={"=sum(CurrSales)>0"} > }   CurrSales))

[Anil_Babu_Samineni]

Try to make it as Data planning / Mock up application. That may useful to explain clearly due to N/A in your application.