SUM is making the formula invalid

CommunityMember126793
Regular Contributor

SUM is making the formula invalid

Trying to pull the SUM of X list from a module but receiving the below error. Source module is having a list datatype line item i.e. COST CENTRE (though dimensioned with other list) and the target module is dimensioned with the subset of the same list COST CENTRE.

When trying to SUM HeadCount based on CostCentre then the formula breaks and not sure why the invalid error is appearing

CommunityMember126793_0-1633937161808.png

 

Note: Only reference to HeadCount is working fine but it is giving the total number of employees.

CommunityMember126793_1-1633937198778.png

CS02: 

CommunityMember126793_2-1633937343781.png

 

2 REPLIES 2
CommunityMember129720
Certified Master Anaplanner

Re: SUM is making the formula invalid

Could it be that the word "count" is restricted and you should quote 'Active Count' in the formula?

CommunityMember126793
Regular Contributor

Re: SUM is making the formula invalid

@CommunityMember129720  Thanks for your time on the issue reponse!

It got sorted out as soon as version enabled in the target module. I haven't understood WHY the SELECT & SUM combination wasn't able to fix that. Since, needed data from a specific version.

But somehow it got sorted.