Forum Discussion

hnowotny17's avatar
hnowotny17
Icon for Helper I rankHelper I
5 years ago
Solved

Sold 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). ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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()
    )

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi  hnowotny17 ,

 

would you like to mark my reply as a solution so that others can learn from it too?

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.