Skip to Content
0
Former Member
Aug 12, 2016 at 07:38 PM

RUNALLOCATION Issue

287 Views

Dear BPC Experts,

We are working on creating a logic script that allocates budget total figures of a year among months using actual figures of 3 years earlier. (Ex. Jan. 2017 budget data should be calculated using actual data of Jan.2016,Jan.2015 & Jan.2014 / Total actual Data in 2016,2015 & 2014

We have created the attached logic script which has 2 problems:

1. Previous year can not be determined dynamically as TMVL is generating incorrect results.

2. Allocation can be done using historical data of 1 year earlier only and not 3 years.

Please advice, How we can handle those two problems.

Thanks and Best Regards

Sara Kadry

Attachments

RUNALLOCATION.png (17.1 kB)