Level 3. QUO06 Tenure Calculation

Gharbali
Gharbali
in Modeling

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,

Best Answer

  • AjayM
    AjayM
    Answer ✓

    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!

Answers

  • Joe_VBCG
    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!

Categories