I need help, I’ve been on this section for a couple of days and can’t seem to figure out why my data is not populating. My formulas are correct but I’m not understanding.
HiIt seems your DAT03 Historic volumes data does not have data for all weeks. Can you check.Thanks,Manjunath
Hello,
yes all of my data is in DAT03. I think I just figured it out. My data for SYS09 vanish but I can’t figure out what section that came from.
Yes all of my data is in DAT03. I think I just figured it out. My data for SYS09 vanish but I can’t figure out what section that came from.
Hi,
From above blueprint view, one can understand that all the four linetems are based on one Baseline Forecast, we can see if you show the clear screenshot(use sipping tool) view of blueprint of your DEM03 or the logic for baseline forecast would do fine 🙂
Here’s my baseline..
hican you show sys01 module. because your baseline forecast line item is applied by if else logic. so by your output you see, it means that your current week is first week in your sys01 module.Thanks
Hey here’s my SYS01, I’m not sure if you wanted the blueprint version or not so I took both.
hi,your value in baseline is correct. you are getting the data for current period only(you can see 1st week is ticked).Thanks
Okay, but why isn’t the rest of my data showing?
Because your formula is coded like that.
Change the code of current period line item to ITEM(time) to see all months data, but kindly put back your old formula after testing.Thanks
So I’m deleting =Time.’current period’ and just keeping ITEM(Time)?
yes, and put back the old formula after testing.
Item(time) doesn’t go through without the complete formula.
for me the SYS01 CurrentPeriod? is ITEM(Time) = TIME.'Current Period' and your DATA03 looks fine
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?