This discussion is archived
6 Replies Latest reply: Feb 14, 2013 9:00 AM by 973110 RSS

Allocation script error

973110 Newbie
Currently Being Moderated
We need to allocate $100 from Selling, Distribution etc. (Lvl 0 members of Function dim) into Product-Channel combination, say in 40% and 60% for Jan.
The users input these percentages in data forms, which can vary for each month.

The $100 is in Selling-> Geography (it is another dim), which needs to be allocated to Prod-Channel combination.

My percentages in data form are in Prod-Channel-Geography.

FIX(@ISLEV(Function,0), @ISLEV(Geography,0), “Prod_None”, “Cha_None”)


This is giving me a parsing error. Please help.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points