Crystal Reports v10 - Formula adding several fields, any of which may be null

[huddy33]

I am not sure how to add these fields together in a formula and always return a value, be it 0 or >0. They are currency fields and the majority of the eight fields will be null. Those that are not null in the formula are still returning a null value overall, after stopping with the first null evaluation. How can I write this?

I've tried trimming the field and <>"", but nothing works. Thanks for any help!

[jggtz]

It could help if you checkMenu/File/Options/Reporting/Convert Null Field Value to Default
so it will be not neccesary to check if they are Null

[KTech]

In SQL I use the isNull function in the query when the records are retrieved

isnull(colName, 0)

[huddy33]

In SQL I use the isNull function in the query when the records are retrieved

isnull(colName, 0)


I'm not sure what you mean; this is the formula I'm trying to modify to skip the nulls and continue to add even if one of the fields is null

{Employees.GroupDisabilityRate}
+{Employees.MedicalDependentRate}
+{Employees.DentalEmployeeRate}
+{Employees.DentalDependentRate}
+{Employees.GroupADDCoverageRate}
+{Employees.GroupLifeCoverageRate}
+{Employees.GroupLifeCoverageDependantRate}
+{Employees.VisionElectiveRate}
+{Employees.SupplementLifeElectiveRate}
+{Employees.SupplementADDElectiveRate}
+{Employees.AFLACElectiveRate}

[jggtz]

See post #2

[huddy33]

See post #2

That did not work. Thank you though.

[rasinc]

That setting in Post #2 is for all NEW reports. Your's is not new anymore. Go to File, Report Options and set the setting there for the current report.

[huddy33]

That setting in Post #2 is for all NEW reports. Your's is not new anymore. Go to File, Report Options and set the setting there for the current report.

This worked! Thank you so much!:)