When working with formulas in your model sheets in Adaptive Planning you may come across an oblique error which doesn’t initially appear to make sense, but once you understand what it is, it becomes fairly obvious what it means (like most errors!).
Problem
So what is the error and how do you fix it?
Have you been writing an
if
statement or two in your formula?
The reason for the error is that it relates to an
if
function used in your formula. You need to make sure the structure of your
if
formula statements contain a truthy capture, and a falsey capture.
For example:
if ( 2 > 1, 3, 0 )
In the above
if
formula, we have a capture of the statement first, which asks: is 2 is greater than 1 (
2 > 1
)?
If the statement is true then we return the first capture in our if statement structure, being
3
. If the statement is false then we return the second part of our if statement, being
0
.
Solution
So look at your
if
statement in your model and check the following:

Is there a
true
andfalse
section to theif
statement? 
If there are nested
if
statements check the brackets are in the right areas.
Simple examples of where I’ve encountered the error in my own model sheets:

I’ve removed a function within the
statement
part of the
if
function and have forgotten to remove all the brackets from within that section, or perhaps I did not have enough brackets:
if ( 2 > 1 ) 3, 0 )

The other times I have made this mistake is when I go a bit crazy on nested if functions and forget one of the outer
if
statements didn’t have its falsey value.
if ( 2 > 1, if ( 3 = 0, 1, 2 ) )
Conclusion
If you come from an Excel or spreadsheet background these errors should be relatively easy to spot. If you are more familiar with a programming language writing
if
statements like this can be a bit of hassle.
If you’re coming from another language just remember the
if
statement is a function and requires 3 parameters.