- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
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;
Views
Replies
Total Likes