i need your help, im struggling with this, i will try to be as clear as possible .
i have this dashboard, column 2 is what i have now and column 3 i what im trying to achieve (i added the column 3 via excel).
i would like to know if its possible to achieve the following setting in anaplan.
the column 2 will be used as a follow up column to tell the end user how much they still need to dispatch. The total highlighted in black is the starting value that is allocated from january to december. The column 2 is supposed to display the remaining amount to be dispcatched for the period, the formula would be starting in february since january will be total for all month ( black highlighted cell) minus january's total :
Column 2 formula should go like this : target value at n = value from the previous cell ( to be allocated value at n-1) minus the total value at n (column 1) . with this, we will end up at zero for the last period ( december )
plus : i will like to know how i can apply a conditionnal formating just in the last cell or in total cell at the bottom.
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.
Re: INCREMENTAL CALCULATION AND CONDITIONL FORMATTING
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?