elly.khanlar
Registered User.
- Local time
- Today, 18:12
- Joined
- Oct 3, 2019
- Messages
- 23
Hi everyone,
I need to have write a formula that will calculate rate based on quarter.
Here is the snapshot of 3 tables I have. I have tried to left Join VolumeTble with MaterialTble based on source and material. meaning if the material 123 is coming from Toronto take the rate from MaterialTbl for the product 123 that is coming from Toronto and
if the in volume table we are going to sell the product in Jan, take the rate from Q1 cost from MaterialTbl and multiply it by volume from VolumeTbl.
if the in volume table we are going to sell the product in Apr, take the rate from Q2 cost from Table and Multiply it by volume from Tbl.
If in the volume table for the months of July-Aug there is not any volume, it shouldn't calculate Q3 cost
I need to have write a formula that will calculate rate based on quarter.
Here is the snapshot of 3 tables I have. I have tried to left Join VolumeTble with MaterialTble based on source and material. meaning if the material 123 is coming from Toronto take the rate from MaterialTbl for the product 123 that is coming from Toronto and
if the in volume table we are going to sell the product in Jan, take the rate from Q1 cost from MaterialTbl and multiply it by volume from VolumeTbl.
if the in volume table we are going to sell the product in Apr, take the rate from Q2 cost from Table and Multiply it by volume from Tbl.
If in the volume table for the months of July-Aug there is not any volume, it shouldn't calculate Q3 cost