Expand the number of decimal places (to maybe 5 places?) for the AVG GPA to see if they're really the same values, or just coincidentally close in value, and the rounding to two decimal places is yielding an illusion of inaccuracy.
All the same, this does feel like something, a problem, that I've seen before. But more detail is needed - a sample of your table values for the fields invovled - to test/model properly.
Hi Data Kruncher,
Thank you so much for your response. Your sugestion to provide sample values led me to the solution. I noticed that the data were showing GPA regardless of the Tot value which meant I needed to add an additional if condition to make GPA null where the value of Tot = 0 as the data came over with the GPA regardless of 0 or 1 in the Tot field. And yes it is familiar as you graciously assisted me with the original formula. Not sure why I didn't notice that the GPA's were there before, so obviously that is why they calculated the same for the entire data set. For reference, here is the revised formula:
I think I'll see about blanking out GPA on the back end, but leave the formula in place so that if it happens again, Monarch will know how to properly calculate.