Creating a new model - issue
I got stuck at one point in building a new module and I thought maybe someone could give me some advice.
1. I built an INPUT MODULE that has a lot of line items (about 30) - some of them are filled uploaded file and some are calculated based on other line items. For this INPUT MODULE data is loaded for two version separately (Forecast, Budget).
Now I'm moving on to where I'm stuck:
2. I need to create a module for this OUTPUT in which I will present the same dimensions, line items as in the input module, but in addition I need to calculate the variance between the forecast and budget value (see the attached photo to visualize)
Create a Line Item Subset, and in the output module new line items (Forecast, Budget, Variance), but I don't know how to get the values for the corresponding Line Items Subset items from the input module. Maybe using LOOKUP? COLLECT?
Thanks in advance for the hints!