Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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..
any suggestions plz
please post a sample app