Forum Discussion

Roman_Zalesskii's avatar
Roman_Zalesskii
Icon for Helper I rankHelper I
3 years ago
Solved

Unit price measure

Hi, need you help. I have a table that looks something like this: Date order № Type of product Collection Price Amount 1/10/2022 OFR-001 Door Slab A 300 2 1/10/2022 OFR-001 Doo...
Need Help
  • Roman_Zalesskii's avatar
    Roman_Zalesskii
    3 years ago

    All problems solved. Dm if you need a solution. 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

How is the hardware Amount playing into the scenario?  What would the expected outcome be based on the sample data you provided?

Roman_Zalesskii's avatar
Roman_Zalesskii
Icon for Helper I rankHelper I
3 years ago

If we take as an example a table, the outcome would be:

Unit price for the collection C: (410+60)/1 = 470

For collection A: (310+40+315)/4 = 166,25

For B: 243/2 = 121,5

 

Order #OFR-001 didn't  taken into account because it consists of two models + hardware. 

Hardware amount also wasn't  taken into account. We only need the price of it.