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

[aaronnayan · Accepted solution]

Thankyou guys

For the help

Originaly it was Null in text

I made a change in the script so it would be easier in the future=    IF(DRIVER>0,1,0) AS JO_DRIVER,

SUM( { < JO_HasDriver={0} > } FUEL_MILES)