Sales rep monthly Commission not matching with Anaplan 'Check Your Build' numbers?

31MB · 2024-05-23T08:57:22+00:00

There was an error rendering this rich post.

Hi All Community Members,

Despite putting a lot of thought and efforts, I am not able to figure out where am I going wrong. I have set all the Modules and formulae in place but still the numbers for the sales rep monthly commission is not matching with the Check Your Build numbers.

Please find below details of my modules I built for this

Quarterly Commission by Rep

Attainment% and Net Commission%

Quarter Apportionment & Monthly Commission Forecast

PS: All my numbers have matched so far with Anaplan Check Your Build numbers so I don't think there should be any mistake at any of the previous steps.

Accepted answers

All comments

KirillKuznetsov

@31MB

Could you show your blueprints of the same modules?

31MB

@Dikshant could you please help me here?

Dikshant

Please share the formulas. I'll give you some clues here, The commission forecast formula logic is:

Quarter Value of Targets * Quarter Apportionment * Net Commission %

Check if this is close to the logic that you have built.

31MB

@Dikshant Yes I am following the same logic. I just calculated it in two steps. First Calculated the quarterly Commission values and then multiplied it with quarterly apportionment in final module.

See my model blueprint below

Dikshant

I can see your Commission Forecast line item in QUO08 module has Quarterly Commission * Quarter Appointment, but i don't see Net Commission %. Can you multiple Net Commission and then check?

rinko

MayurBodade

i did it, :)

fisrt of all, you should build a

Quartly Final Account Sales Target module

then use this data for your calculation module's target line item, you will get the correct answer

cheer!!!

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…