As you go through the process of building out your Financial Model with Adaptive Insights, there will be many formulas you need to create to represent accounts and business calculations. When that number of formulas becomes large enough, tracking down any formula errors can be difficult and time consuming. Luckily, Adaptive provides the Formula Validation…

When viewing the calculated Headcount or New Hire accounts on a standard sheet you may receive “Error: This formula refers to a time period which does not exist”:           When using dot notation, users will get the above error on the Headcount formula when an Employee’s Start Date is prior to…