INCREMENTAL CALCULATION AND CONDITIONL FORMATTING

Yes, if you are using Native Time, then you can use the previous() function which you will need.

Something like this?

HI,
yes something like this. could you please explain or show what do you mean by native time? i tried using the time module i have with this formula but it didnt work.

i have this error : 'LAG' function may not be used if the result line item does not have a timescale

Yes, some people use a custom time list vs using the one that is native to Anaplan, which it looks like you are and I would question as why you aren't working with the "real" time list that is native to Anaplan. If you use the "real" time list/dimension, then the above will work because you can you the Previous() and LAG() functions which you can not use with custom lists.

With the error message you received , you are not using the "normal" time list, but rather a custom one.

Hope this helps,

Rob

Ok, this may sound stupid but how to use the native time ? i tried by creating a new module with the automatic time as dimension but i still can't figure why i am getting the same error. could you please share a pic of the 'SYS Time Filter-Month'.FY Year blueprint?

Not a stupid question, I should have detailed it out better and now I just realized we can make it more peformant with less calculations (amazing what a good night sleep will do for you).

Create a SYS Time module using Time with the following line items:

Line Item	Format	Formula	Summary	TimeScale
First Time Period	Boolean	LAG(1, 1, 0) = 0	None	Month
Month Only	Boolean	TRUE	None	Month
FY Year	Year	item(time)	none	Month
FY Year Bool	Boolean	TRUE	None	Year
Month and FY Year	Boolean	Month Only or FY YEAR Bool	Formula	Month

Create a module for your calculation, I called mine Allocation.

Create a line item for the input, mine is Data to be Allocated and is a number format.

Create another line item called Final $ with the formula:

IF 'SYS Time Filter - Month'.First Time Period THEN Data to Allocation[LOOKUP: 'SYS Time Filter - Month'.FY Year] - Data to Allocation ELSE PREVIOUS(Final $) - Data to Allocation

Notice, this is different from the original one because now I am looking for the First Time Period in the SYS Time Filter module and just referencing it instead of redoing the calculation again.

Hope that helps,

Rob

Thanks a lot,
i followed all these steps but i got this error :

LOOKUP using DATE mapping SYS TIME.FY Year is not valid in this case because Total VAT included does not apply to Time

Look at your formats and compare them to mine. Or, put a picture of your blueprint when you respond so I can see what is going on.

Hi,

pics of the blueprint:

and the formula im trying to apply to allocation :

IF SYS TIME.First Time Period THEN Total VAT included[LOOKUP:SYS TIME.FY Year] - Total VAT included ELSE PREVIOUS (allocation) - Total VAT included

Thanks a lot for your time 🙂

You can't use a fake time list, you will need to use the real time list as you did in the SYS Time module. Now, if you must you the fake/custom time that you have for reporting reasons, then we can do a mapping to get the data there after you use the module with Real Time.

Rob

Hi,

i think it would be way too much complicated to use Previous or any time dimension related function since we use pretty much only customisezd time dimension and changing this will take some time; Do you perharps know a way to still implement the calculation without using a time dimension? something like if starting date= january then total allocation - january's allocation ELSE previous cell - current total allocation ".

attached a simple visual showing the idea