-
Is there a way to hide zero value line items?
Hi All, Can someone help me how to hide zero-value line items in a model or dashboard (within the dimensions). regards Sudhir
-
DCA based off of a user in a module
Hi all, Wondering if anyone knows of a way to matchup the user from a module with the user list used in the DCA module. Obviously you cannot lookup based off the user list, so wondering if anyone has a workaround.
-
Finding the next non blank field
Hi, This must be simple but it is driving me mad What formula do i need in the Next Non Blank line item to find the next non blank date? Thanks
-
Rolling data snapshots of Weekly and Monthly forecast for different Versions
We have a scenario where there is a need to do a weekly forecast for short term (next 13 weeks) and monthly forecast for remaining periods of the fiscal year. The forecast and actuals need to be captured in both weekly view and monthly view. Also the monthly view needs to be tied to a consolidation system (another tool…
-
Finditem in Subset (Works!)
In a prior post, I'd asked if there was a way to use the FINDITEM function to determine if a list item is a member of a subset. The answer at the time was no, but you could create a line item with an Applies To on the subset, and set the formula to TRUE, then you could create another line item with Applies To on the full…
-
Confirmed PO Delivery - OFFSET
Hello, 3.3.5.1 Create Inventory Ordering Module I'm having the hardest time understanding which line item to use in the Confirmed PO Delivery formula. The threads I've read keep referring me to the POST function, but I'm not at that point in the training yet. The following set of instructions are confusing me: * Set the…
-
Forecast Data using TIMESUM function
Hi Team, I have one situation, where I am calculating a Line-item in Forecast scenario using Sum of Last 12 months (from the Current Period). Need your inputs to help with the below model design. Scenario 1: Current period = Jan 2021 Actual Version = Jan 2020 till Dec 2020 Forecast Version = Jan 2021 till Dec 2021 (i.e.…
-
Quarter value as numeric numbers
Hi All, Required a quick help in getting the quarter number as numeric format. For example in attached screenshot, need to get the value for second line item as entered. All Q1 Months should populate with numeric number 1, all Q2 should be populated with number 2 and so on.... Quartertodate() function gives a numeric…
-
Confused on how to use Min Function
Hi, I' trying to use a Min function to take the min Account Balance in a month. This is the function I thought of using but it is not working. Both are formatted as Numbers. 'Y02 Accounts'.'Closing Balance (01)'[MIN:'S01 Time Settings'.Day # of the Month] Thank you
-
Capturing uploading timestamp in a line item in module
There is a requirement where, when we are importing data in a module, the current timestamp when the file is uploaded in the module should capture that time in line item.
-
Need support with Time Management using DCA
Can anyone help me what's the best way to identify - Current Year Current Quarter, Current Year Previous Quarter, Previous Year Current Quarter using DCA and Boolean.
-
How do I find a line item in a list subset?
Hi, I have a module in which I'm trying to determine if accounts are within an account list subset, if so return TRUE, so that I can then filter those records to import to another module. I cant get the finditem to work for me, is there another way to do it? I also tried using a line item subset, but failed... the…
-
Level 1 Lesson 11.3.4
I have been stuck on the first formula for days. When I enter it the error I get is: I'm not sure what this means, I have gone back and double checked the naming of all of my modules and made sure I was typing the formula correctly: IF 'SYS09 Version Details'.Forecast? THEN 'EMP02 Employee Expenses'.Headcount[SUM: 'SYS08…
-
Level 3 Sprint 2 Section 4.5
Hi, Section 4.5 says to check my build on the Accounts Exception UX. I am not sure if there was an activity to build that. Am I supposed to build the UX pages basis the mock-ups we created in the beginning?
-
End of Month Totals in a Module.
How do I get end of Month Totals to show in a Module that is has a daily time dimension?
-
P3 SKU 0 Failed Invalid parent
Hi on the Level 1 model building exam, I am trying to import the SKU csv and I get a message saying invalid parent and I dont know why. Wold you mind helping me ?
-
How do I get the total from one module to another?
In module 1, I have a count for resolved and unresolved. In module 2, I would like the total for unresolved items and resovled items. How do I do this? I know in Excel it would be a simple sum formula. Module 1: Module 2: Thanks!
-
Level 1 Model Building - Estimated Exam Time
Hi - I'm ready to take the Level 1 Model building exam. From the instructions it seems I should plan on completing in one session. I'm planning my week, how much time do you recommend setting aside to take the exam?
-
Retrieve Current User
Hello, I can use item(user list) to get current user, i.e. the user who login current system, it requires to use user list as dimension. Now I have a module which is not dimensioned user list, is it possible to retrieve current user directly without adding user list as dimension? Thanks in advance.
-
Deriving the month/quarter value from the line item
Hi I have a line item ' Transaction Date' formatted to 'Date' . Sample value : 01-08-2021. I am trying to derive the Month,Quarter and Year from this Date value in the below sample format. Month: Jan 21 Quarter :FYQ1 FY21 Year:FY21 Is there any formulas to derive these values? Thanks Prabakaran