All,
I have query that I've added an expression field to calculate the total of values in columns.
When I run the query, I get values that are not only not accurate, but not even possible. This is making it hard to troubledshoot the issue.
My formula is:
Total Score: ([BB_Site_Readiness]![BB Integration Step 1 complete]+[BB_Site_Readiness]![BB Integration Step 2 complete]+[BB_Site_Readiness]![BB Integration Step 3 complete]+[BB_Site_Readiness]![Detailed Process Map Reviewed/Approved by site]+[BB_Site_Readiness]![Org Assesment and Additional Resource Req Approved by Site]+[BB_Site_Readiness]![Metrics Defined, Tracked and Results Acceptable]+[BB_Site_Readiness]![Effective QSE-Site Communication])
Most of these fields have values such as 5 or 10, but I'll get totals such as 16 or 13, which by looking at the values in the fields is not possible.
Help?