You have a Personnel sheet that calculates a cell phone allowance paid each month unless...

The business rule states that the cell phone allowance is paid each month unless an employee has earned over a certain salary threshold for the year. This requires a year-to-date cumulative check — the system must compare the employee's cumulative salary earned to date against the annual threshold to determine if they have crossed it in any given month. The correct expression ROW.CumulativeSalary < ASSUM.CellThreshold compares the running cumulative salary (year-to-date earnings) against the threshold assumption. If cumulative salary is below the threshold, the allowance is paid; once it exceeds the threshold, the allowance stops. ROW.Salary compared to divf(ASSUM.CellThreshold,12) compares a monthly amount to a monthly portion of the threshold, which does not reflect cumulative earnings. ROW.Salary[time=last.year] references prior year data, not the current year accumulation. ROW.MonthlySalary compared to the annual threshold would only fire when a single mont h's salary exceeds the full-year threshold, which is incorrect logic. Reference: Workday Adaptive Planning — Personnel Sheet Formulas, IF Statements, Cumulative Functions.