Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey, guys. How do I display the last price of an item on the date of sale? Unable to set a date.
FirstSortedValue(${DateSales={"">=$(Max(DatePrice))""}}price,-DatePrice)
What if there are two prices for a particular DateSales with Max DatePrice?
display the maximum price
So trying to withdraw, and always shows the last price
Not sure I understand your requirement?
Example,
at the DateSales 02.06.2018 и 10.06.2018 to bring the price from DatePrice 05.05.2018
Since the DateSales 02.06.2018 the price of the product was 0.05
at the DateSales 09.07.2018 to bring the price from DatePrice 04.07.2018
Since the DateSales 09.07.2018 the price of the product was 0.02