SAP Analytics Cloud - Distribute Budget equally to 12 months

[rachugh]

Hi,

We have already completed Budget/Planning cycle. Now users wants to automatically distribute Budgets to 12 months. Is there easy way as I cannot go back to users and suggest them to make line as 0 and input at Total column. There are too many lines. Is there any logic which can be written? Or how can I use Distribute/Allocation logic?

[N1kh1l]

@rachugh 

You can write a Data Action to distribute the total budget numbers equally to months. Simply divide the total budget by 12 and post it to months. As your total budget is also on months may be you can just separate the data intersection for the total budget and monthly distribution for reconciliation purpose in case of distribution errors.

Nikhil

[rachugh]

Thanks Nikhil. I would really appreciate if you can help with sample code.