-
Level 1 11.3.4
Hi, Even if I enter the formula as instructed, The sample and answer are different. Any help is appreciated. Thanks. This is my model: This is the should be:
-
Level 1 10.2.6
Hi, Even if I enter the formula as instructed, it is not reflected. Any help is appreciated. Thanks.
-
Level3. Territory>Account module
Hello, I created a module in Data-Hub to transfer the territory>account to Sales Planning model in a numbered format to use as a dimension. However, I am pretty sure that something is incorrect with my module cause all the accounts listed in each territory repeatedly. Any idea what is wrong here? Thanks,
-
Anaplan does not sum the filtered list items but it sums all list items
Is there a way to sum only the list items that I filtered? Now All directions is always the sum of all the list items and not only the list items that I filtered
-
Level 1 9.2.5 Unit Price %
Hi, When I try to copy and paste this formula I get the below error and cannot seem to work this one out. The formula for 'REV05 Price Growth Rates Staging'.Unit Price % is invalid: Unit Price % = 'REV04 Price Growth Rates'.Unit Price%[LOOKUP:'SYS04 Location Details'.Country, LOOKUP:'SYS06 Product Details'.Product Family]…
-
Level 3. QUO01 Territory Account
Hello, In the QUO01 module, I am using formula below to get target number, but I get 0.00; I even tries to add LOOKUP account names but still no luck. Also, for Assing>1 I am writing this formula, but it errors out: IF 'SYS07 Territory Account Details'.Count[sum:'SYS07 Territory Account Details'.Account> 1 THEN TRUE ELSE…
-
How can I permanently HOLD the TOTAL figure and let the Breakback happen?
Hi Community, Need your help if you have a smart solution to HOLD / LOCK the Top/Total of certain dimensions of a line item which is Breakback enabled! Example screens is given below: So, all I want is to HOLD the yellow circle i.e. 1849 amount and let the below gets change which is 4 levels hierarchy.. We know the HOLD…
-
Loading .csv File issue Numbers dots, commas
Hello, I have an issue when loading my .CSV file, the number I get they are not right: when importing, the system takes the dot from the numbers as being the number not the decimal. For ex, in the CSV file I have 22.2 so twenty-two point 2 and in Anaplan I get 222. Can anyone help with that please? thanks
-
Need a filter for FY months
Hi community, I need a formula to filter my module months based on current fiscal year. For example, if my FY is 24 (FY24), I want to filter the module to show all months for FY24 (Jan to Dec). After that, I want to show text 'Actual' for actual months and text 'Forecast' for forecast months. Below is a illustration of…
-
Filtering a subset
Anaplanners, Is there a way i can filter a subset ? So, we have Projects module, where each project can be either active, inactive or done. This is a list formatted line item. However, the option to select done should be based on another line item in the module, actuals uploaded : Yes/No ? If the boolean is true only the…
-
Level3. Territory>Account module
Hello, I created G3a Territory in Data-Hub rolled up to G2 country. And loaded with Territory Data via CSV file that has been provided in the sprint 2. I created a sys module with a dimension of G3a Territory and Account to create the needed info for Territory and Account# in the Sales Planning Model. However, I see some…
-
Anaplan level 2 sprint 1 exam passed but not count
-
Display next 2 period (month)
Hi everyone. I'm not quite sure if i'm using the correct formula in displaying the next 2 month period. if I selected Oct 24 in time dimension, the result would be display is Dec 24 in my column. is used this formula NEXT(NEXT(ITEM(Time))) which is running and no error. Just to make sure if i'm using the correct formula.
-
Lock Lookup. Possible?
Hi everyone is there any possibility to lock the lookup function when using offset? what i want to achieve is when i change my time period, the awarded will take the current period in module Construction Forecast-Awarded and will be place in Awarded column. same thing in Awarded 2nd Month, it will display the second month.…
-
Level 3. Account Review UX page
Hello, I created a saved view from the actual module and created a UX page for Account Review. In the Module "Country" and "Segment" are subsidiary. I can't figure out how can I use them as a page selector in UX page. Please advise. Thanks,
-
Level 3. Sum the stretch goal% in FY
Hello, Can you please help me to find a way to have 1% in FY. If I select "Sum" in Summary section it will add up the percentages to 4%. I would like to see 1% in FY total also. Thanks,
-
Potential Typo in 3.3.5.2D Remaining Line Items
I thought it should be "less" instead of "plus" Thoughts?
-
Superset Choice (from Time Ranges)
Could someone please explain what's the use of this particular time lookups function?
-
Selected Time from another module
Hi everyone. is it possible to get the selected time from module 1 to module2 as line item.? thank you.
-
Average of previous year and current year
Hello community, I need to calculate average of previous year end (e.g FY23) and current year end (e.g. FY24). Logic should be FY24 + FY23 / 2. How can I return these vales from a line item which has both FY23 and FY24 numbers. Any ideas much appreciated. Thanks Kal