Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

BOM quantity changing over time

Hi All,   I previously had a query (link below) on how to link a BOM to ingredient costs in order to workout total raw material costs for a product. The solution was simply mergeing the tables whic...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous 

    Do you mean that your old data will change and you want to show the old data and new data at the same time to make a comparison? If you want to use merge to solve your problem, I suggest you to add a new table to show update data and merge them to show result you want.

    Here is my Sample.

    If this reply still couldn't help you solve your problem, please share a sample with me. And you can show me a screenshot of the result you want. This will make it easier for me to understand your requirement.

     

    Best Regards,
    Rico Zhou

     

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous 

Do you mean that your old data will change and you want to show the old data and new data at the same time to make a comparison? If you want to use merge to solve your problem, I suggest you to add a new table to show update data and merge them to show result you want.

Here is my Sample.

If this reply still couldn't help you solve your problem, please share a sample with me. And you can show me a screenshot of the result you want. This will make it easier for me to understand your requirement.

 

Best Regards,
Rico Zhou

 

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