Chart Expression

[#1]

Hi there,

I have an Gauge Chart whiche works. I have some datas which are 0.00 and it would be great if the chart ignores the 0.00 that it does not pushing down the avg. The Expression is Avg(Value).

[Anonymous · Accepted solution]

Try an expression that tests for Value not being 0. Something like:

avg({<Value='{<>0}'>} Value)

... or using an if statement ...

Avg(if(Value<>0, Value))

Jonathan

[#3]

Thanks Jonathan

I tried the first expression, it didn't worked. It showed nothing.

With Avg(if(Value<>0, Value)) it workes fine.

And also thank you for the fast answer

[#4]

Try this if you dont want the If-statement.

Avg({<Value-={0}>}Value)