simple set anlaysis with WHERE clause

[aaronnayan]

Hi guys i need help with some set analysis

I want to =SUM(FUEL_MILES) where DRIVER is NULL

Fields:

FUEL_MILES

DRIVER

[jmvilaplanap]

Hi, Try with this

sum({<Driver={''}>}FUEL_MILES)

[vishsaggi]

Try this:

= SUM({< DRIVER = {"= Len(Trim(DRIVER)) = 0 "} >} FUEL_MILES)

[Anonymous]

try

sum({$-<DRIVER={"*"}>} [FUEL_MILES9])

[Chernov]

SUM( { < DRIVER -={'*'} > }  FUEL_MILES)

-= : mean NOT

'*' : mean All values

[aaronnayan]

I want this set analysis to calculate FUEL_MILES when there is no driver. (NULL)

[Anonymous]

I think that won't work. You'll get the empty set.

[Anonymous]

is your "NULL" null() or 'null' ?

[effinty2112]

Hi Aaron,

Maybe:

=sum(FUEL_MILES)-sum({$<Driver={"*"}>}FUEL_MILES)

Cheers

Andrew

Edit : Robin has written his expression in a far better way than mine. I think my formulation is easy to understand but once you do understand what's going on Robin's expression should be used.

[vishsaggi]

Did you try any of the expressions suggested? How is your null represented? Like actual word Null or '-' hyphen?