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!
@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.
@Dikshant Thanks, it makes sense actually.
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.
@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.
@Csta, Can you share the blueprint mode of the module TAR05 Quarterly Account Sales Revenue Targets.
@dilkshant here it is. I was able to figure many other things, ambiguities with the Qtr Percentage still persist.
@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]
It is pulling values from the QTR so we don't need the look up but the SUM for only A1 Accounts. @Dikshant
Hello everyone, We are trying to use Anaplan Connect in order to push data from a dwh to Anaplan Data Hub. To do so, we need an authentication by token. We can't make it work, we receive the following error: ERROR 16020 |-- Anaplan API: Invalid key path Any suggestions? Thank you all in advance for the help! Michele
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
