I need some advice/guidance. I'm building a tiny model that looks at the number of components used in products.
We have one component that can be used in 5/6 products. The end result that I'm trying to achieve is a module that shows me data by components.
What I've done is created a numbered list called "infeed data". Within this list, I have my components and products. I've created a mapping to make sure that products are unique. Manged to feed the data in and it's working correctly.
The second part of this is feeding some of this data into a module. I'm a little stuck on how to go about collating all the data for date fields.
I've attached the properties for my list and the module I want to feed data into. Lookup/SUM isn't working.
Essentially want to pull in RDD, ETD, ETA against "mapping to model" in my module.
One method could be to convert the date into a number and then use SUM and then convert back into a date.
How would I go about doing that?
Or if you create a saved view you could try an import process. The saved view might work. Would I need to create an intermediate module where my list data would be fed into. Then create a saved view import into my final module?