Aggregating values from 2 cells

[#1]

Hi,

This is what I've got atm which returns me a value, but I would also like to add the sum of another value: sub_exec_broker={''NEONT'}. Aggregating these two, in a total. Anyonwe that can help?

[Gysbert_Wassenaar]

If there are no records where both exec_broker and sub_exec_broker have the value NEONT then you can use this:

Num(Sum({<exec_broker={'NEONT'}>+<sub_exec_broker={'NEONT'}>}TurnoverSEK),'#.##0')

Otherwise you may want to use this instead:

Num(RangeSum(Sum({<exec_broker={'NEONT'}>}TurnoverSEK),Sum({<sub_exec_broker={'NEONT'}>}TurnoverSEK)),'#.##0')