1 Reply Latest reply on Oct 21, 2018 9:19 PM by Josh Ciszek

    Mixed Aggregate Calculation

    Josh Ciszek

      Got tired of googling...

       

      I simply want [Late Assess %] by dividing [Count - Assess not within 30 Days] by [All Clients] (i.e. [Count - Assess not within 30 Days] / [Count - Assess not within 30 Days] ) at the level of the rows (i.e. Not assessed, Single Only, Matched Pair), but simply making a calculated field gives me the dreaded aggregation error.  The furthest I have gotten is that "Late Assess %" calculates on the aggregate sum of "All Clients."

       

      See image below of the 2 calculated fields for my numerator and denominator.

       

      Untitled.png