Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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')