L3 Sprint 1 - User Story 5
My Percentage is not matching
This is my Ratio. Let me know where I'm going wrong.
hi @Dikshant
I believe your formula of
PY sales by country and prod family is wrong , since you are referring to forecast data , the value should be actual PY sales by country and prod family i,e PY
i have referred PY sales numbers
then this ratio aggregated by country and prod family should be 1 since basically ratio is of account sale by country and prod family associated with that account
hope this helps
@Dikshant
Not sure I see the calculation breakdown but you do have a lot of subsidiary views that could be the cause. Generally we only use subsidiary views when we need them for filtering (exports and reports). For planning, it's usually better to rely on system modules that carry the mapping. In this way we calculate the value once and refer to it often from one place. This also avoids issues with synchronizing calculations since the calculation is only coming from one place.
Chapter 2 - Anaplan Community (2.01-06) Avoid Subsidiary Views.
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
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.…
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385
