Hi Gene,
If this is on the Detail section then you don't really need a running total but you will need the variables. Try this:
numbervar x; numbervar y; numbervar z; numbervar ColumnSum; ColumnSum:= x + y + z ; if {@Text1}="N/A" then ( x := 0 ; ) else if {@Text1}="N/A" then ( x := 1 ; )...etc. ; if {@Text2}="N/A" then ( y := 0 ; ) else if {@Text2}="N/A" then ( y := 1 ; )...etc. ; if {@Text3}="N/A" then ( z := 0 ; ) else if {@Text3}="N/A" then ( z := 1 ; )...etc. ; x + y +z;
The reason it only shows column 3 is because that's the last thing the formula evaluates. You need to tell have the formula sum the 3 columns.
Good luck,
Brian
Add comment