I am using this formula 'DEM03 Demand Forecast'.Final Forecast to pull final demand forecast value, but I am not getting any values.
Hi @suraj_Anaplan
can we see the blueprint of the DEM03 module, please? or a drill down of the "forecast demand" line item in INV01? Thanks
Hi @AlejandroGomez , here is the screenshot of DEM03 Module. Please
but does DEM03 have "Time" dimension? If it does not have it, then I would say that in your INV01 module, for the LI "Forecast Demand" you should include the SELECT function: [SELECT: time.all periods] (also assuming that you have the "all period" summary enabled in your time dimension)
Else, does the list "Accounts" have a top level item?
Hi ALL, I have a module where a line item (Assignments column) is formatted by a large ‘Projects’ list. Each record is assigned to a Project and this module is published to a UX page. When users apply a filter on the Assignments column, the filter dropdown displays the entire Projects list (since the column is…
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?