expression does not work when indicating a field needs to be empty.

[#1]

I hope this is not a stupid question, but I tried and searched for half an hour and it still does not work.

Who can help me?

I have this as an expression on a bar-chart.

Count(if ( [Stage Type]='Transport' and [Event Type]='Order Confirmation' and [Plan / Actual]='Actual' and [Actual Time of Arrival]='' , Alert))

What here does not work is: [Actual Time of Arrival]=''

I only like to have the rows, where the [Actual Time of Arrival] does not have a value.

[#2 · Accepted solution]

Hi there,

[Actual Time of Arrival]=''

I believe that is looking for a zero string rather than a proper null, so it depends on what is in your data,

try

isnull([Actual Time of Arrival])

instead and see if that works

thanks

Joe

[#3]

Hi stormy,

depending on your source you may have real null-values in your field [Actual Time of Arrival]. In this case the expression above won't work. Try this instead:

if(  . . . IsNull([Actual Time of Arrival], . . .)

HtH

Roland

Soory, was a bit late. I agree with the post above.

[#4]

Thanks.

Works