8 Replies Latest reply on Oct 14, 2013 9:41 AM by Emily Le Coz

    Agg and Non-Agg Fields - Help!

    Emily Le Coz

      I know this has been asked before, and I apologize for covering the same ground, but I have tried the solutions posted in previous threads with no luck.

       

      I have two fields: SUM(Number of Records) and AGG(Unique Provider Numbers). I want a table calculation that returns SUM(Number of Records) / AGG(Unique Provider Numbers).

       

      I get one of two errors depending on my possible workaround. It either says I can't mix agg and non-agg fields. Or that I can't further aggregate and agg field. I've tried everything. Help?