Stuck with a Cross dynamic board

[#1]

Hi all,

I' ve a problem with my crossed dynamic board. It consists of an Indicator Number and of a set of figures which brings to a total. For information the last 3 are expressions and the others dimensions. In certain cases, if a column is not informed calculates it will not made the result(see the picture)

For information :

Disponible à engager = Montant Glo - Franchise - Frais HE - Cumul ER

Total = Versement D. + Versement I. + Réponse Recours

Balance = Dispo - Total

For example:

If we take the second line of the board, we see that "Cumul Eng. Réa.' so the 'Disponible à engager' too and of the blow the balance also.

How can I calculate them when certain values are not here?!

Thank you largely in advance

[whiteline]

Hi.

You could use rangesum() function. It calculates the sum of expressions and omit null values.

I guess the problem is that you use '+' '-' signs, and if any operand is null the result is null.

[#3]

Hi and thx  whiteline,

What the difference between Sum() and RangeSum() ? I've try in my expression to use RangeSum([Val1]+[Val2]) for example. I don't have '-' but '0' instead. But that don't solve my problem.

I think your right about the '+' '-' signs but I sure there is a way to deal with null values.

[whiteline · Accepted solution]

Sum - aggregation function that sums the field values.

RangeSum - function that sums expressions, omitting nulls.

null + some expression result = null

ramgesum(null, some expression result) =  some expression result

You can read the QV help.

[#5]

That's works for me thx you whiteline