5 Replies Latest reply: May 15, 2014 10:05 AM by Data Kruncher RSS

    Create Nulls For Avg Calculation

    sxschech _

      I'm using Monarch V8.01 and looking to summarize avg gpa.  I made the following formula, but haven't figured out how to make it null if the condition is false.  When doing an Average GPA including 0 changes the totals.

       

      The formula editor allowed this:

       

      If(ACCEPTED=1,GPA,0)

       

      However, what I would like is for the formula to be

       

      If(ACCEPTED=1,GPA,null)

       

      I can't really filter because I was hoping to be able to have the three averages (Applied GPA, Accepted GPA, Enrolled GPA) side by side in the summary window as the counts are displayed that way currently.