Here is my situation:

1. I have some formulas set up to calculate next year's budget based on this year's actuals. So I have a formula in the Budget cube which basically says Sales = "2008", "Working Budget" = "2007", "Actual" * 0.5

2. To make the budgeting process more dynamic, a user can enter an "Override" to manually enter the data instead of using the formula.

3. So the formula in (1) above becomes something like If field x = "Override", Stet(), "2008", "Working Budget" = "2007", "Actual" * 0.5.

This all works great. (And thanks, by the way, for the rules engine, they make all the difference!)

Once these numbers are in the db, I can then perform more calculations on them. For instance, i can have COGS = Sales * 0.1 and this formula would work for either the *calculated values* or the *overriden-entered values*. All is well.

But the problem seems to be when I try to use an IF statement. For instance, if I put in change the Rule above for the COGS calc to be something like:

COGS = If Sales > 1000, Sales * 0.1, Sales * 0.11

the result is a #NULL! for the "overriden-entered values" only. The other values work fine.

Any thoughts on this? I can post the exact rules and attached spreadsheet if that will help describe the problem. Thanks,

Mike