About jspascual

Hello,    Good day to you, all.    I would like to ask this question that's been bugging me for days now.    Situation:    1. I have a module that houses actual data primarily used for uploading a csv file. This does NOT have time dimension as the the period is only a line item. But since the model calendar is from 2018 to 2022, it can house data way back 2018.  2. I have another module that is always in the current year (2022)-- so this is using a Time Range from Jan 22 to Dec 22. In this module, we are putting in for example a projected savings from Jan 22 to Sep 22. The amount is spreading as expected.   3. There is a module which serves as the baseline input. Users put the baseline start and baseline end period. For example, user puts Jan 19 - Sep 19 on this module.   4. The challenge is, how to compare the two modules using different time dimension. The actual spread coming using model calendar from 2018-2022, and the other module from #2 is using always the Current Year, 2022. How to pull the amounts from  Jan 19 to Sep 19 and place the amounts to Jan 22 to Sep 22 so they can be compared?     Thanks a lot for your ideas.   Regards,   Jon ... View more

Hello, Just a quick question please on the NUX Apps, do they consume space?  Thanks, Jonathan ... View more

Hello,   I would like to ask if there's a way to make the drilldowns in Anaplan to only show items with data on them <> 0, or isnotblank? Currently, I need to scroll down a lot to locate to the account that has the relevant data.   Thank you,   Jonathan     ... View more

Hello,   I hope you are all doing well and good.    I would like to ask about a challenge that I'm currently experiencing.    Situation is, I need to create an action, just a simple action that will be published to the NUX. This will be an Import action within the same module via a Saved View.    Please refer to the encircled line items below. I want the red to load its data to blue.  When I run the import, it says, it has been successfully completed. But the TRUE value did not load to the target line item. It's still unchecked. Thanks for all of your inputs.      Submit? Load >> Submit Reject? Load >> Rejected?        Thanks!   Jonathan ... View more

Hello,    I hope you are all doing well.   I need some help on my calculation.    Issue is, I need my ending balance of the prior period to be the beginning balance of the current period.  The thing is, these movements (beginning +/- movements = ending balance) are all members of the same list.  It just does not come forward.    The formula goes like this:   IF ITEM(PPE Cost Movements) = PPE Cost Movements.Beginning Balance THEN PREVIOUS(Line Item in Issue[SELECT: PPE Cost Movements.Ending Balance]) ELSE 0   It should take the 284M as the beginning for Jan 20 and not the loaded 295M anymore.   Thank you,   Jonathan   ... View more

Hello,    I hope you're all doing well.   I have this problem that's preventing me from proceeding on to the next steps.    I'm trying to rank the basic salary from lowest to highest, by position.  As we all know, even if employees have the same position, there are instances that they don't have the same salary. The idea is, I need to get the lowest salary per position.  The issue I'm encountering is that, if I do a rank formula, it does return the correct order when there are more than 1 employees.  But if the position is assigned to only 1 employee, meaning only 1 employee has that position, it always returns 2. I need the value to be 1 since that will be my basis of getting the salary amount: IF Rank = 1 THEN Basic Salary ELSE 0.    Thank you for all the inputs you may share.   Regards,   Jonathan ... View more

Hello,   Many of you have probably finished the Level 3 Model Building Certification.  As I start Level 3, Sprint 2, I got confused with the below instruction: My questions/clarifications:   1. In Sprint 1, the Level 3 Model is connecting with the Data Hub, and there was an option to download a New Data Hub or Use the Data Hub in Level 2 Model Building. I used the Data Hub in my Level 2 Model Building. There is no Territory List in Level 2 Data Hub. Where can I import the data? Do I have to create a new list for Territories in the Level 2 Data Hub? See screenshot below: 2. Do I really have to do it in the Level 2 Data Hub? It seems that it's already in the Level 3 Model itself, both in List and Sys module:       Thanks so much!   Jonathan ... View more

Hello,    I am having this difficulty since last night, I can't figure out how to address this issue.  If anyone has encountered this issue before, what did you do to solve this?    Situation:   1. I have created saved views inside the same module. I'm using saved views to import to the very same module.  2. The module has a custom version such as Budget Year and Forecast Year... and cuts such as Current cut and Previous Cut 3. The use of the saved views is to import the same information from Budget Year to Forecast Year , or from Current Cut to Previous Cut, into the same module 4. I have a specific line item in the module that I can't seem to import. It's the "Equipment Category" line item. It has a list Format and is a subset of another list, and it's a numbered List.  5. Issue is, when I try to import the populated Equipment Category, an error would occur: "Item not located in ss: MEQ Capex Element Leasing list: Air Compressor" --- but I know for sure that it's listed there.    Screenshots attached.    I'm trying to import the Equipment Category from Current Cut to Previous Cut for the same Budget Year:   In my mapping, I use connect to Anaplan model > Saved View and select that saved view I created. I'm only changing the custom version in the mapping because I want the information in the Current Cut to be imported to the Previous Cut:    The line items are mapped correctly as well: But when the import is ran, I'm getting the below error. Notice that it has 2 errors in it, and it looks like it does refer to the 2 populated equipment categories for "Air Compressor" above:    Here's the subset and Air Compressor is really in it, what am I doing wrong? 😞                ... View more

Hello,   I'm getting an error when changing a line item's summary  from "Sum to Formula: Time, Sum":   "Invalid combination for line item 'Sales' of summary method 'Formula' with formula using LOOKUP and/or SUM (or other summary function)"   The formula of the line item does indeed have a Sum function, and I'm getting it from another module which has a "Formula: Time, Sum" summary. I would like to be able to get the same amount as that module summed by industry for example:    SourceModule.Sales[SUM: Industry]    But because they have the different summary, I'm not able to get the same results.    Thanks in advance for any input you can give.   Thanks,   Jonathan         ... View more