Expression ???

[#1]

Hi All,

I have a Straight Table object.

I need to Display the values of the table, where the Amount = 0.

[#2]

I need only fields, where the Amount = 0. Can anyone help me with the Expression ?

Thanks,

Praveen

[manojkulkarni]

Check attached file..

[sundarakumar]

PFA

[MK_QSL]

Use

=if(SUM(Amount)<>0,SUM(Amount)) as Expression and

In Presentation tab

Select Supress Zero Values

This one will give you non-zero

Sorry My Mistake...

=if(SUM(Amount)=0,SUM(Amount)) as Expression and

make sure in Presentation Tab

Supress Zero Values not selected

This one give you zoro

[sundarakumar]

Hi Praveen,

Manoj have used script whereas i have done the same with calculated dimension.

It is better to use edit scrit since calculated dimension can reduce your performance if u have lot of data.

Sundar

[nizamsha]

Try this in this dimension

=Aggr( if(sum(Amount)<=0, Name),Name)

[#8]

Hi Manish,

I too tried in the same way

=if(SUM(Amount)=0,SUM(Amount)) as Expression and

make sure in Presentation Tab

Supress Zero Values not selected

It is showing fields which have zero. But it is also displaying the Nonzero values as '-'. I wanted to Suppress the non zero rows as well.

[#9]

Hi Manish,

I used ur second Expression.

It is displaying the Field values where Amount =0.  Its good.  But it is also displaying other rows where amount = non zero. It is dioslpaying those row's value as '-'

[MK_QSL · Accepted solution]

Check enclosed file... Hope this might help you.