Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
the KIP i need to show is
# parts with multiple prices with same supplier
what i understand is , i need to show number of materials which is supplied by same supplier having more then one distinct price and validto has to be greater than today()
Dimension :Supplier
Expression:
aggr(Count({<SCOPE={'Yes'},VALIDTO={">$(=Date(today(),'DD-MM-YYYY'))"},supplier={"=Count(Distinct Price)>1"}>}distinct part),supplier)
i am getting materials , suppliers which has only one price ,which should not ,so i think the greater than syntax in my expression
has problem,
any suggestion plz..
Thanks
1) I don't think you need Aggr() in your expression
2) May be try this
Count({<SCOPE = {'Yes'}, VALIDTO = {">$(=Date(today(),'DD-MM-YYYY'))"}, supplier = {"=Count({<SCOPE={'Yes'}, VALIDTO ={"">$(=Date(today(),'DD-MM-YYYY'))""}>} DISTINCT Price)>1"}>} DISTINCT part)
try below put "= "
aggr(Count({<SCOPE={'Yes'},VALIDTO={">=$(=Date(today(),'DD-MM-YYYY'))"},supplier={"=Count(Distinct Price)>1"}>}distinct part),supplier)
1) I don't think you need Aggr() in your expression
2) May be try this
Count({<SCOPE = {'Yes'}, VALIDTO = {">$(=Date(today(),'DD-MM-YYYY'))"}, supplier = {"=Count({<SCOPE={'Yes'}, VALIDTO ={"">$(=Date(today(),'DD-MM-YYYY'))""}>} DISTINCT Price)>1"}>} DISTINCT part)
thanks for your reply ,
i have used aggr because in different KIP i need to group it with plant wise ,so without using aggr how can i able to group with plant
Count({<SCOPE = {'Yes'}, VALIDTO = {">$(=Date(today(),'DD-MM-YYYY'))"}, supplier = {"=Count({<SCOPE={'Yes'}, VALIDTO ={"">$(=Date(today(),'DD-MM-YYYY'))""}>} DISTINCT Price)>1"}>} DISTINCT<Plant> part)
is above expression a valid one
Group by plant? Not sure I understand? can you elaborate?
i mean for a particular plant ,supplier combination how many materials has distinct multiple prices supplied by that supplier .
Then I believe you will have to use Aggr() function instead of set analysis
Hello , i have used the below expression which suggested by you
Count({<SCOPE = {'Yes'},MATL_TYPE={'HALB','ROH'}, VALIDTO = {">$(=Date(today(),'DD-MM-YYYY'))"}, [MATERIAL CODE]= {"=Count({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'}, VALIDTO ={"">$(=Date(today(),'DD-MM-YYYY'))""}>} DISTINCT PRICE_MAT)>1"}>} DISTINCt [MATERIAL CODE])
before selecting vendor i am getting wrong output
after selecting that vendor i am getting correct o/p
can u suggest me y this is happening
Looking at screenshots and expressions doesn't give me much details Naveen. Would you be able to share a sample to dig deeper. Also, it would be helpful to know the expected number you are looking to get with and without selections
i wish to do so but it is client data which i am not allowed to share ,to keep it simple the number i am getting after selecting vendor (1,2)should appear even if i don't select vendor because they are correct num