Avatar

Level 5

Hi,

Can you not just change the if statement to do something like this.

if (( Table3.Row1.currentgoal1.rawValue != null) && ( Table3.Row1.currentgoal1.rawValue != "NA"))

{

     goalcount++;

}

this should mean that the goalcount only gets updated if the currentgoal1 is a value that is not "NA"

Regards

Malcolm