Avatar

Level 2

Hi Malcom,

Thank you for the quick response.  I entered the formula in the first goal count only however, it does not seem to work.  Would it need to be added to all in order to work?

HIRE.#subform[6].INDIVIDUALGOALHEADINGSECTION.goalcount::calculate - (JavaScript, client)

var

goalcount = 0

if

((

Table3.Row1.currentgoal1.rawValue

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

goalcount

= goalcount++;

}

if

(Table3.Row2.currentgoal2.rawValue

!= null){

goalcount

= goalcount + 1;

}

if

(Table3.Row3.currentgoal3.rawValue

!= null){

goalcount

= goalcount + 1;

}

if

(Table3.Row4.currentgoal4.rawValue

!= null){

goalcount

= goalcount + 1;

}

if

(Table3.Row5.currentgoal5.rawValue

!= null){

goalcount

= goalcount + 1;

}

if

(Table3.Row6.currentgoal6.rawValue

!= null){

goalcount

= goalcount + 1;

}

if

(Table3.Row7.currentgoal7.rawValue

!= null){

goalcount

= goalcount + 1;

}

if

(Table3.Row8.currentgoal8.rawValue

!= null){

goalcount

= goalcount + 1;

}

if

(Table3.Row9.currentgoal9.rawValue

!= null){

goalcount

= goalcount + 1;

}

if

(Table3.Row10.currentgoal10.rawValue

!= null){

goalcount

= goalcount + 1;

}

if

(Table3.Row11.currentgoal11.rawValue

!= null){

goalcount

= goalcount + 1;

}

if

(Table3.Row12.currentgoal12.rawValue

!= null){

goalcount

= goalcount + 1;

}

if

(Table3.Row13.currentgoal13.rawValue

!= null){

goalcount

= goalcount + 1;

}

if

(Table3.Row14.currentgoal14.rawValue

!= null){

goalcount

= goalcount + 1;

}

if

(Table3.Row15.currentgoal15.rawValue

!= null){

goalcount

= goalcount + 1;

}

this.rawValue

= goalcount;