@ankit_cheeni You are a genius, thank you very much!!! I have another question, if i want to pull the average of the previous 3 months, how can i do it? Regards!!
... View more
Hello, I need to get data from Aug 21 to Sept 21, but i dont want to use "Previous month", if not something like "current month -1", it´s possible? Thanks
... View more
Hello, I have a Price List named "Raw Materials Price", and I need to pull from "Component Cost Increase" module the % increase by Component, Plant and Period (Jan 2021), hoy can I consider the period in the lookup formula? Raw Material Price List: Formula: Component Cost Increase Module: Thanks, regards
... View more
Hi @Akhtar.shahbaz, thanks for the reply, You have reason, but now i have an issue, and it is that the father does not have the SUM of the total price, how can i put the total price as in your model? Thanks, Luis
... View more
Hello Community, I have the next list named BOM Lvl 1 List, with a Total Price Column, But, I need that if Semi-finish are TRUE, go to the list named BOM Lvl 2 List, and pull the price, adding up the price of the children: Thanks!
... View more
Hello, I have a situation, I have a list named "BOM Lvl 1", with the parent "plant sku", and these parent have a "total price". Then, I have another list "SKU Plant Price" where the "Plant SKU" is the same in two lists , and i need to accumulate the total price in these new list: Thanks, have a good day!
... View more