Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
can any one help me in finding out what's wrong with my expression,i am trying to display z-part spend which has been supplied by multiple vendors.
let say sample data
Z-part vendor spend
001 xxx 100
001 yyy 200
001 zzz 300
002 yyy 100
003 kkk 150
003 aaa 50
what i am trying to display in a straight table is below
Z-part vendor sum(spend)
001 xxx 100
001 yyy 200
001 zzz 300
003 kkk 150
003 aaa 50
only the parts which has been supplied by multiple vendors
Dimension: z-part,vendor
expression:
sum(Aggr(If(Count({<[In Scope]={'Yes'}>}DISTINCT [vendor]) >1,[vendor],Z-part ),spend))
but i am getting Zero as output
any help plz...
Thanks
Hi,
Try this:
Sum( {<[Z-part] = {'=Count(vendor) > 1'}>}spend)
Cheers.
Try:
Sum({<[Z-part]={"=Count(Distinct vendor)>1"}>}spend)