what wrong with my expresssion

[kunkumnaveen]

Hello,

          i am trying to display Single material supplied by multiple vendor

Dimensions: Material , Vendor Name ,Vendor Code

expressions i tried  are :

1)Spend:

Num(Sum({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'},Material={"=Count(Distinct [VENDOR CODE])>1"}>}Spend)/100,'#,##0 ')

                                                       or

If(Count(distinct TOTAL <Material> [VENDOR CODE])>1,Sum({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'}>}SPEND))

2)Quantity:

Num(Sum({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'},Material={"=Count(Distinct [VENDOR CODE])>1"}>}VOLUME)/100,'#,##0 ')

But  the expressions not giving me correct o/p

even though the vendor name and vendor code are same but they are two different materials ,they should be considered when i am showing Multi sourced  vendors  because each material as only one supplier..

can any one help in this plz

[kunkumnaveen]

even though the vendor name and vendor code are same but they are two different materials ,they should be considered when i am showing Multi sourced  vendors  because each material as only one supplier..

even though the vendor name and vendor code are same but they are two different materials ,they  should not be considered when i am showing Multi sourced  vendors  because each material as only one supplier..

[kunkumnaveen]

any suggestions plz

[vinieme12]

please post a sample app