return zero in sum calculation
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.