### Title

Can't get fields to add up

### Post

I have calculation field **MPQuota** with calculation

Let ([

SummaryYrMo = Year(Date_Meal Plan) & Right ("0"&Month (Date_Meal Plan); 2);

Today= GetAsDate (Get(CurrentHostTimeStamp));

TodayYrMo = Year (Today) & Right ("0" & Month (Today); 2)];

Case (TodayYrMo = SummaryYrMo; 1; 0)

)

Then a summary field, **s_SummMPQuota, **has the Total of **MPQuota**

I have a calculation field MPQuota% with calculation **( s_SummMPQuota ) / ( Trainers::SummaryActive )**

This gives me the % that I want for each trainer. But when I try to create a field to total all these percentages I get a blank for the outcome. I created calculation field TotalAverage MPQuota, Count ( MPQuota% ) / SummaryActive Trainer

So the category under New Meal Plan should be Averaging that column.

That's not how a count function works.

Count ( field )

will return 1 if the field is not empty, 0 if it is.

Count ( RepeatingField )

will return the number of non-empty repetitions

Count ( relatedTable::field )

will return the number of related records where the field is not empty. (both times that I refer to "field", i mean a non-repeating field.)

Therefore the only possible values for: Count ( MPQuota% )

are 1 or 0.