Average and Constant

[tracycrown]

Dear all

Please advise how to make headcount (No.of Students) to be fixed (ie. as numbers as worksheet, not average) with averages for English and Science subjects in one report.

Thank You for your help

Tracy 

[jerem1234 · Accepted solution]

You can use an if statement to evaluate one expression for number of students, then another for everything else like:

if(Result = 'Number of Students', sum(Data), RangeAvg(Before(Data),Data))

Hope this helps!