Correct the expression

[kunkumnaveen]

Hello All,

                 i am able to achieve my requirement  partially . the thing is i am trying to display only those materials,spend which has supplied by multiple vendors.

All the 100% spend are materials which is having single vendor code ....

so how to remove those 100% rows

Please correct my expression ....

PFA qvw file...

thanks

[arvind_patil]

HI Naveen,

Please try this one and check:

If(Sum({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'},New_Column={"=Count(Distinct [VENDOR CODE])>1"}>}SPEND)/

Sum({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'},New_Column={"=Count(Distinct [VENDOR CODE])>1"}>}total <New_Column>SPEND) <0.99,

Sum({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'},New_Column={"=Count(Distinct [VENDOR CODE])>1"}>}SPEND)/

Sum({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'},New_Column={"=Count(Distinct [VENDOR CODE])>1"}>}total <New_Column>SPEND))

Thanks,

Arvind Patil

[kunkumnaveen]

hello arvind, a very thanks for your reply, the thing is when i use ur expression i am able to remove all the materials which is having one vendor code (100%)

but problem is the expression all so removing materials which has as shown in the below

total spend and % showing me null

[arvind_patil]

HI Naveen,

I have seen value shown not 0 but in percentage, it covers only small share that's why it shows 0 percent.

If i Remove % then look like below:

Thanks,

Arvind Patil