Forum Discussion
hnowotny17
Helper I
Helper ISold Value counted from two Pricelist
Hello, I would like to kindly ask anyone for the help. I have a table with products, sold quantity and pricelist (price/product) and I would like to count "Sold Value" (Sold quantity*Price). ...
hnowotny17 , Try a new column like
Switch( True(),
[Date] >= date(2020,01,01) && [Date] <= date(2020,04,30) , [Pricelist S1] * [sold quantity],
[Date] >= date(2020,05,01) && [Date] <= date(2021,01,31) , [Pricelist S2] * [sold quantity],
blank()
)
amitchandak
Super User
Super Userhnowotny17 , Try a new column like
Switch( True(),
[Date] >= date(2020,01,01) && [Date] <= date(2020,04,30) , [Pricelist S1] * [sold quantity],
[Date] >= date(2020,05,01) && [Date] <= date(2021,01,31) , [Pricelist S2] * [sold quantity],
blank()
)
hnowotny17Helper I
Helper IDear AmitK
thank you for your time to help me with this case. I tried your solution and it perfectly works!
Kind regards,
Jan N