Nz() issue in expression Builder (1 Viewer)

[rghaddad@inco.com.lb]

Good afternoon,

I am trying to use the Nz expression as part of my Expression Builder Formula, however when I click OK the following message appears:
The Expression Nz([Old Stock]) + Nz([New Stock]) cannot be used in a calculated column.
Can anyone help?

Thanks.

 

[Misiek]

Try this:

Nz([Old Stock],0) + Nz([New Stock],0)

or this:

Nz(sum([Old Stock]+[New Stock]),0)