Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this?
Count({<terms = {"=Count(DISTINCT terms) > 1"}>} DISTINCT terms)
Or simply
Count({<terms = {">1"}>}DISTINCT terms)
Try like:
If( your count expression >1, your count expression)
Then enable null suppression as well.
Count({<terms = {'>1'}>}DISTINCT terms)
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
hi ,i am getting zero ,where did i went wrong
count({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'},[Delivery Term]={">1"}>}distinct [Delivery Term])
hi ,i am getting zero ,where did i went wrong
count({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'},[Delivery Term]={">1"}>}distinct [Delivery Term])
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])
)
Check your SCOPE field value whether it is in upper format or lower
or try like MATL_TYPE={"HALB","ROH"}
Hi i have used the above expression ,how to remove these rows