Expression in text object

[#1]

Hi

I have created the following expression in a text object:

= If(Delay>=0,NumericCount (Delay))

Expressions seems to be OK, but I doesn 't give a result.

= -

What could possibly be wrong ?

Thanks in advance.

Marc

[datanibbler]

Hi Marc,

that happens sometimes when your condition is not met and you have not specified an alternative in the IF construction.

[swuehl]

Try

= NumericCount (If(Delay>=0,Delay))

[#4]

Hi

It works, thank you very much.

Grt

Marc

[#5]

Your expression only works when you select Delay fields because your aggregation scope limited to only one value.

Please try: NumericCount(IF(Delay>0,Delay) --> In this the aggregation scope to total Field values.