AnsweredAssumed Answered

return zero in sum calculation

Question asked by otto_m on Jun 7, 2010
Latest reply on Jun 9, 2010 by comment_1

Title

return zero in sum calculation

Post

Thanks to SuperContributor "comment" for this valuable hint my report:

 

Sum ( 
1 ;
Score ≥ 22 ;
Score ≥ 43 ;
Score ≥ 85 ;
Score ≥ 153
)

It works well and ranks the number of applicants in levels 1-5 according to their score.

 

There is just one little thing: FM omits the fields that are zero, often resulting in columns of three or four rows only.

 

For comparisons, it would be good to have FM 11 return zero for levels without appropriate scores, consistently resulting in five rows.

 

How can I accomplish this?

 

Thanks in advance for your help.

 

Otto

Outcomes