INCREMENTAL CALCULATION AND CONDITIONL FORMATTING
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.
Thanks in advance