AnsweredAssumed Answered

Can't get fields to add up

Question asked by danlee on Apr 27, 2015
Latest reply on Apr 30, 2015 by danlee

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.

Screen_Shot_2015-04-27_at_9.17.45_PM.png

Outcomes