Quarterly Account Sales Revenue Targets

This data from here is impacting a lot of things and I am not sure if the % taken to distribute the Sales Target over the Quarters is the same as PY Account/ PY Country Product Family.

Help plx!

Accepted answers

Dikshant

@Csta, We need to divide the Initial Account Sales Target of that quarter by the Total Sales Target for the whole month to get the percentage. Try it out! Also it's mentioned in the notes to use LOOKUP function.

Csta

@Dikshant Thanks, it makes sense actually.

All comments

Dikshant

Make sure your logic on 'TAR02 Account Review'.Final Sales Targets is working correctly and you have loaded the override Sales Target correctly is loaded correctly.

Csta

@dilkshant The Final Sales Target Seems fine as per the comparison with the example that was given.

The Quarterly Distribution is what is confusing.

I am taking this % for Distribution over the Quarters.

Dikshant

@Csta, Can you share the blueprint mode of the module TAR05 Quarterly Account Sales Revenue Targets.

Csta

@dilkshant here it is.

I was able to figure many other things, ambiguities with the Qtr Percentage still persist.

Dikshant

@Csta, Can you try this formula for % of Account Sales Target line item:

'TAR01 Detailed Sales Targets'.Initial Account Sales Target / 'TAR01 Detailed Sales Targets'.Initial Account Sales Target[LOOKUP: 'SYS99 Lookups'.Target Year]

Csta

It is pulling values from the QTR so we don't need the look up but the SUM for only A1 Accounts. @Dikshant

Dikshant

Csta

@Dikshant Thanks, it makes sense actually.

Quick Links

Can you help?

Unanswered questions

Different Subsets of Parent Lists in Input & Output Modules
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
Is there a way to turn off the Show Comments Summary panel in UX pages with Comments?
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
Are there any plans to support actions to rename or delete native Versions?
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!