SUM for two line items (in the same module) that have a common list format

joshkhanzadeh

Hi,

I'm trying to SUM two line items in a model - currently we have the below which works:

THEN
'[SUM: 'PL 1. P&L '] ….

As we want to SUM two line items in the module, we have tried the below (and other SUM formats) but failed with the comment the line items have the same list format. If somebody could advise it would be appreciated. (ERROR: Mappings have a common LIST format)

THEN
'[SUM: 'PL 1. P&L', 'PL1. P&LB] ….

THEN
'[SUM: 'PL 1. P&L]' + [SUM: 'PL1. P&LB] ….

(I've also tried creating a new module, and then summing this, but it still won't work)

TIA,

Josh

andrewtye

In the 2nd example is the P&LB on a different dimension? Don't forget that when using SUM the reference field needs the same list format as the target module.

Without seeing the whole line item hard to say where exactly it's going wrong.

Have you tried just duplicating the original, so 1+1 and then just change the line you're summing. It should work