Level 3. QUO06 Tenure Calculation

Gharbali · 2024-11-13T21:32:11+00:00

There was an error rendering this rich post.

Gharbali

Hello,

Can you please review my formulas here:

Screenshot_13-11-2024_152823_us1a.app.anaplan.com.jpeg

i am not sure why I see 5+ years here for everyone:

Screenshot_13-11-2024_152748_us1a.app.anaplan.com.jpeg

Thanks,

Accepted answers

AjayM

in QUO06, for start and end, you should be comparing high/low with numbered format of length of service, not sales rep's completed years. And then you can pull the 'tenure list' into sys08.tenure.

Cheers!

All comments

Joe_VBCG

@Gharbali It appears there is a dimensionality mismatch between the modules. Without seeing the rest of the model, I can only say to focus on making sure you have the correct dimensions in the destination and source modules.

I hope this helps!

AjayM

in QUO06, for start and end, you should be comparing high/low with numbered format of length of service, not sales rep's completed years. And then you can pull the 'tenure list' into sys08.tenure.

Cheers!

Quick Links

Can you help?

Unanswered questions

Invalid Name
Hello Experts, Greetings for the day!! I am trying to import data from data hub into spoke model. While I am importing I am facing one error "Invalid Name". I have checked both data hub and spoke model same list item is present in both models and there is no mapping issue. Could you please help me with this issue..…
Has anyone taken a stab at Master Anaplanner Recertification exam yet?
Just curious :)…
Solution for indent diabled for hierarchical list when the page has more than two axis
Hello fellow Anaplaners, I have a question about the UX for Anaplan for hierarchical list. If I have a list with multiple layers, say P1, P2, P3, and P4, and the workpage had 2 axis, list and line items, in its vertical axis and time in its horizontal axis (see figure below) The list is shown without indentations, and may…