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 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with a sample without sensitive data.

 

Best Regards,

Rico Zhou

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

    Apologies for the late reply, I had been locked out of my account. The different BOM quantity amounts were in the same rows as the current BOM quantity amounts. To get around this I made a new colum called BOM  Active which would return "1" if the price of the ingredient fitted into the time period the BOM ingredient active. I then enabled this column as a filter which worked. Thank you for your help!