Total errors per row

[Fadius]

I have an audit report looking for errors. First Column is the assigned person name, then each other column is different fields of data. If the data is incorrect, it displays missing.

What I am needing is a count in each row of all the errors per row.

How can I accomplish this?

For each field of data or column, there is a seperate formula with criteria that if it isn;t met, it will display missing.

I can get column totals easy enough, just not the row totals.

Thanks in advance.

 

[Charliy]

You need a formula at the end of the column that adds up the "Missing" items. Without seeing your report or data I can just give you something in the ballpark:

(if {@flag1} = "Missing" then 1 else 0)
+
(if {@flag2} = "Missing" then 1 else 0)
+
. . .

Make sense?

 

[lbass]

Or, you could create a formula like this for the detail section:

stringvar array x := [{@field1},{@field2},...{@field24}];//list the detail level formulas in the array
numbervar i;
numbervar j := ubound(x);
numbervar k := 0;
for i := 1 to j do (
if x = "Missing" then
k := k + 1
);
k

Make sure that the "Missing" in the formula is in the same case that is returned in the fields.

-LB