Hello ,
I try to create a calculated field that sums up other fields however there are empty fields so value will not appear in the Calculated field
Is there a way around this problem ?
Thanks
G
Hello ,
I try to create a calculated field that sums up other fields however there are empty fields so value will not appear in the Calculated field
Is there a way around this problem ?
Thanks
G
Modify expression in your calculated field to something like:
But it's rarely good idea to store calculated values, you'll be better off to use query when you want to calculate something. In query you can use Nz() function to go around null values.Code:IIf(IsNull([Field1]),0,[Field1])+IIf(IsNull([Field2]),0,[Field2])...etc
This code works fine
Thank you