Creating an average from chart expressions

[#1]

Hi,

I've created several expressions from which I need an overall average.

The sum expression I've created is a simple addition:

Expression1 + Expression2 + Expression3 .........

However, the expression only gives a value if all the expressions have a value.  How do I get a total/average if any of the constituent expressions is missing?

Any help on this gratefully received,

Racine62

[marcus_malinow]

try using

rangemax(Expression1, 0) + rangemax(Expression2,0) etc.. etc...

[maxgro · Accepted solution]

look at alt function

the result of alt(null(), 0) is 0

or at the rangesum function

from online help

rangesum(expr1 [ , expr2, ... exprN ])

Returns the sum of a range of 1 to N arguments. As opposed to the + operator, rangesum will treat all non-numeric values as 0.

[#4]

Thanks for this,

Racine62