I got something to solve and would like to ask for help.
In ANAPLAN, there are set up automatic draw payments for Austria AT. This logic, was called off by the end of Q1. In the sales statement report, filtering the Austria AT, my colleague still see Draws for July and August.
Who can help me to sort this out? Where do I have to make change, so draws for July and August for Austria AT are gone?
I understood there is a logic in place when you said June and September are already = 0, no worries
Is the underlying data for MTD and QTD draw for June and Sept = 0 or just the final value is replaced by 0.? What I mean by the underlying data is the data used to calculate the final value of the line item. You can get this information by looking at the formula of the line item and trace it back to the source, alternately you can trace the source of the data by using Drill Down (F8)
Is this a one-time thing - replacing the values for July and August with 0 - or you expect you will have to do it again for different months or different entities?
I don't want to give you a nonsustainable logic as IF July or August then 0 Else calculate. This is a very bad practice.
So, I am trying to find out if you need to view the July and August real values somewhere else in the Application or you want it to be zero everywhere? Examining how the result of 0 was achieved for June and September will help us follow the same logic instead of creating 2 different logics for the same line items.
The solution could be as simple as replacing the input values used to calculate the MTD and QTD for the desired months = 0. That will save the integrity of the formulas for the whole model, however, if you need to see these values somewhere else in the application then we have to be careful how we accomplish that.
Einas "Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"