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
Note: Only reference to HeadCount is working fine but it is giving the total number of employees.