Help with SUM
I have a target module containing a dimension which I need to map into a line item. Taking the system module containing the source dimension I have created a line item subset containing the line item in the target and mapped the target line item to the source dimension.
In addition to this I have a line item subset as a dimension in the source which I am mapping into a line item subset which is a dimension of the target. I am using a system module dimension as the source LISS and mapping this into the target LISS.
When I build the formula using two SUM functions no data is pulling through to the target. I do not receive any error and the formula simply returns zero.
When I replace the first SUM with a SELECT the data successfully flows through to my target module.
I am baffled as to why the first SUM is failing but not generating any error. I need to SUM as two list items in the source need to aggregate into a single line item in the target.
Any and all ideas as to why this is happening would be happily received.