Displaying Null Values with Expression Builder (1 Viewer)

[DBDUDE]

Hi. I am using Expression Builder to total 3 columns for a query.

Total: [BaseTotal]+[ClickTotal]+[Adj Total]

The [Adj Total] is sometimes empty, and when this happens, Total is empty even though there are values for [BaseTotal] & [ClickTotal]. How can I make the Total show up regardless of whether any of the three items used to calculate it are Null?

Thanks

 

[KenHigg]

Maybe:

Total: nz([BaseTotal])+nz([ClickTotal])+nz([Adj Total])


???

 

[DBDUDE]

That did the trick, thanks much!

 

[KenHigg]

You're welcome -