Summarize two different fields

[Former Member]

Hello,

I need to summarize two different field, but the sum should be per group.

I attached 3 files:

first field, second field, design.

If I create formula like this:

Sum ({Foglio1_.importo fondo}, {Foglio1_.TOTALE})+Sum ({Foglio1_.competenza anno di riferimento del bilancio n (spese)}, {Foglio1_.TOTALE})

it works only for first group, then it will blank.

How I can do it?

[abhilash_kumar · Accepted solution]

Hi Roberto,

I don't see an issue with the formula.

Where is this formula placed? It isn't clear from the screenshot as you've highlighted a field on the details section.

-Abhilash

[Former Member · Accepted solution]

I've modified the structure, but with the same result.

Here a new image that explai the problem.

[abhilash_kumar · Accepted solution]

Open the formula > in the formula editor you should see a dropdown on the top that reads 'Exceptions for Nulls'.

Change that to 'Default Values for Nulls'.

-Abhilash

[Former Member · Accepted solution]

Thank you again Abhilash.

It works like a charm