Lvl 3 TAR04 Account segment total by country

Hi,

I was validating my build of TAR04 module. While my All Segment data is matching, the individual segment data(small,medium,large) aren't. See attached image; first grid is my build and second the one from training.

I checked my system module and all segments are mapped to each account. what is it that I am missing?

Comments

ChrisAHeathcote

@kunal_311

Check your summary settings.

kunal_311

Hi @ChrisAHeathcote

I used SUM as summary settings as it allows sum for all segments & for all regions. I tried other summary settings but they did not work.

My solution

Training Solution:

ChrisAHeathcote

@kunal_311

I can see from the screenshots that the totals by country match.

The totals by segment are different therefore the problem must be in the mapping.

I recommend that you import the data that informs the mapping again as it appears that the distribution in your mapping is different that the example.

kunal_311

Hi @ChrisAHeathcote

First of all, Appreciating your guidance on the said issue.

The mapping was already there in the "SYS02 Account Details" module which we got by downloading the Level 3 Starter model at the start so No import as such is done by us in that case.

To cross-check I again downloaded the starter model and rechecked my values in "SYS02 Account Details" and they are correctly mapped.

kunal_311

I was able to figure it out.

FlorianB

Would you mind shedding some light on how you solved it? I encountered the exact same problem, and also have correct total values, but incorrect segment values.

DenisaBontas

Hello,

I Have the same problem here. I downloaded the model again, but the I think that the mapping of the segments are different now from the ones that were used in the training solution.

Do you have any solution for that?

Thanks

image_129100.png

jpackham

Hello,

The mappings are correct if you've taken them from the Level 3 Starter model. I initially redownloaded as well just to be safe. I know that @Misbah had made a comment in another thread on this - Take a look at your source for the sales targets by segment, are you using the initial sales target, the final, or something else? Hopefully this helps without giving anything away.

Good Luck!

algrigore

Can you please advise how you solved this issue?
Thanks

elif

Right, you did reference sales target to populate those numbers but make sure from which sales target column you need to pull the data

Nab7

How were you able to do so. Care to share.? 🙂

As you learn from us, we want to do the same

tinathom

Make sure that you check your values in TAR04 Account Segments Total By Country Module after you have imported the file provided. This mismatch is because that. Read carefully and proceed.

megha09

How did you do this?

megha09

Did you find any solution for this?

lilasququ

I have exactly the same incorrect values by country. What was the solution for it?

AjayM

Hi @lilasququ ,

As others hinted already, please recheck your formula - which sales target are you referring from the source?

Cheers!

sdavidko@ciena.com

@lilasququ - I am sorry but what is the MATH for Final Sales Targets?

sdavidko@ciena.com

Can someone dummy it down for me and tell me how to derive FINAL account sales rev targets. It is obvious to me i should not be using INITIAL targerts but FINAL instead. What and what do I add or substract or multiply to get to FINAL? Thanks

Quick Links

Recent release news

May 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our May 2025 official release notes. The information below offers supplemental information to that post. Integrations and extensibility Preview dataset when mapping to model or selecting for transformation view in ADO When selecting a dataset to map to a…
April 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our April 2025 official release notes. The information below offers supplemental information to that post. UX New UX for Models section in Administration The Models section in Administration has been redesigned with a more intuitive interface. Tenant…