Level 3 - Quaterly Distribution Percentage according to previous year data
I think my Quarterly % calculation is not correct because according with the example on the user story 1.11:
The Years total is correct in my case but not the Quarters:
Based on training explanation the % should be calculated considering previous year data, therefore I've created the following line items:
- Historical Account Sales Target, from DAT04 Historical Revenue by Product aggregated for all the Products on the same Account f, this is provided in a csv file
- Total Historical Account Sales Target, from DAT04 Historical Revenue by Product the whole year.
- % account Sales target then is Historical Account Sales Target / Total Hist Account Sales Target
But seems is not correct, because for example considering Account Candyate the percentage should be 24,46549% but in my calculation is 24,5192%
Is that historical data the proper one to be used to calculate this %?
Thanks in advance,