Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
i have a problem with a Best-Price-Calculation.
There are a lot of items equal items, with many vendors.
Below you see a list of one item, from 7 different vendors.
What i try to get now, is to find the Bestprice and the second-bestprice. Via SQL-Statement i already get the first bestprice, but not the second.
My Main-Problem sems to go with ALL,$,TOTAL,{1}.....
When i try this, i get what i want, but only when the filter is for one item. When i have all items, it is min() for all items 😞
What i want is:
when this is set correctly, min()-function would give me what i want.
Thanks a lot for help!
Best regards
Andreas
May be try like
= Min(Total <Item-No> {< ....>} LieferantenArtikel.sale_price_calculated)