SELECT not working when SUMming from a Module with a Numbered List

Options
drock
drock Member, ALL USERS, Community Pioneer Posts: 2 Master Anaplanner of the Year
in Planning & Modeling

Fellow Anaplanners,

 

We have a summary module in our Headcount planning application which pulls from both the new and existing headcount module. The new headcount uses a numbered list, existing headcount module does not. We have two formulas documented below....in the first one, we are pulling from the existing headcount module which is using a regular list and it works perfectly:

 

'Employee Comp - Detail'.AOP Existing Comp[SUM: 'Employee Comp - Detail'.'Dept', SELECT: Version List.'CY AOP']

 

The next formula adds a SELECT for only taking the approved comp from the New Employee Expense:

 

New Employee Expense.Comp [SUM: New Employee Expense.Dept, 'SELECT: Status.Approved, SELECT: Version List.'CY AOP']

 

The result in the second formula pulls values, but completely disregards the SELECT and gives us an inflated value. Has anyone seen this before? Is there a workaround besides creating another module which changes out the numbered list for a static list?

 

Thanks in advance for your suggestions!

 

Tagged:

Categories