3 Replies Latest reply: Jul 6, 2017 2:15 AM by Arvind Patil RSS

    Correct the expression

    naveen kumar

      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

        • Re: Correct the expression
          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