how to write expression

[kunkumnaveen]

Hi all,

i need to show only those plant and suppliers whose terms are more then 1

plant      supplier         terms( expression i wrote is  count distinct terms)

xxx          aaa                  4

yyy            bbb                  3

zzz           ccc                     2

kkk           ddd                    1

hhh           eee                    1

but what i need to display is only those terms >1

plant      supplier         terms

xxx          aaa                  4

yyy            bbb                  3

zzz           ccc                     2

how to achieve this plz

thanks

[Anil_Babu_Samineni]

May be this?

Count({<terms = {"=Count(DISTINCT terms) > 1"}>} DISTINCT terms)

Or simply

Count({<terms = {">1"}>}DISTINCT terms)

[tresesco]

Try like:

If( your count expression >1, your count expression)

Then enable null suppression as well.

[prma7799]

Count({<terms = {'>1'}>}DISTINCT terms)

[prieper]

You may restrict the view in a table with an expression like

IF(terms > 1, terms)

terms might be replaced by an aggregation, in case need.

You may also restrict your data in the dimension, e.g.

IF(terms > 1, supplier)

Peter

[kunkumnaveen]

hi ,i am getting zero ,where did i went wrong

count({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'},[Delivery Term]={">1"}>}distinct [Delivery Term])

[kunkumnaveen]

hi ,i am getting zero ,where did i went wrong

count({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'},[Delivery Term]={">1"}>}distinct [Delivery Term])

[tresesco]

May be this ?

If(

count({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'}>} distinct [Delivery Term]) >1,

count({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'}>} distinct [Delivery Term])

     )

[prma7799]

Check your SCOPE field value whether it is in upper format or lower

or try like MATL_TYPE={"HALB","ROH"}

[kunkumnaveen]

Hi i have used the above expression ,how to remove these rows