nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Lesson 9.2.5: 5% turns into 420%

Clarke

Hello All

I have a question I hope someone can help me with.

I input 5% on my F19 for REV 04 , then i receive 420% for my REV 05

Is there antone who can help me out?

Screenshot_2022-08-17_14_145001.png

Comments

wskagegard

Hi,

What does your function look like in REV05? Do you lookup against country and product family? Do you have the correct country and product family that you are comparing?

Do you have correct format of the percentage?

RavinderB

In the staging module you need to select a product and location also.

Are you sure you are using 2 Lookups in your staging module formulas? Hint : look at your system modules for product family and product location.

Once this is done correctly, you will see the relevant % in the staging module from the % in the first module.

Ravinder

wskagegard

It looks correct to me. Double check weather you have the right country and product family in your systems modules.

Clarke

Hi Wskagegard,

Thank you for your reply.

Somehow it multiplies the 5% with the amount of times the product family "Chocolates" is named in SYOS06 Product details and the amount of times the US location is named in the SYOS04.

5*14*6

Does this provides more info to help me get to the proper solution?

Screenshot_2022-08-17_16_145021.png

wskagegard

Ah now I know what the problem is. You have the wrong dimensionality in the REV05 module. There you should have location and product as dimensions. The level of country and product family you already have in the REV04 module.

Clarke

That's a good comment- however I am already using the location and product as dimensions.

Screenshot_2022-08-17_17_145035.png

wskagegard

Ok so what percentage does it give you for one product that has chocolates as product family and a city that has us as country. If it gives you 5% it works. I cant see anything on country and PF level in my model. That's because I dont have any summary on. MAybe you have summary on your line items in REV05?

Clarke

Hi wskagegard ,

How stupid of me- sorry for wasting your time.

I was indeed looking at the sum -.-"

My bad!

Quick Links

Recent release news

April 2026 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our April 2026 official release notes. There you'll find information on: Polaris Trigonometry functions MOVINGSUM on general lists Line item limit Security and tenant administration CAPTCHA on basic authentication Anaplan XL (version 2604) Offline writeback…
Recording now available! April 29 platform release event
If you missed our April 29, 2026 platform release event, the recording is now available! In this webinar, we highlighted the most recent feature releases and how to take advantage of these in your environment. Our expert-led session demonstrated new features and innovations, provided a technical deep-dive and “how-to”,…