Skip to Content
0
Former Member
May 18, 2007 at 03:20 PM

Example FOX formula top-down distribution based on reference data

37 Views

Hello,

we use IP 7.0 and are looking for an example of a FOX formula which performs a top-down distribution using actual data as reference data (multi-provider combines actual and planning cube). The reference data however should be selected with a variable "period from" - "period to" and an average value should be returned from the actuals (so if three periods selected -> calculate average of three periods from actuals and use it for top-down planning data. Does anyone already did this before?

thanks

Dries