9 Replies Latest reply: Jan 25, 2016 9:32 AM by Stefan Wühl RSS

    # Months Over Target

    Dermot mcgoldrick

      I have a calculation that checks % records meeting target by month.  This works well but as an additional col in a straight table I want to show the total # months the target was achieved.


      Using examples online I have this :


      Count(DISTINCT if( only(aggr( count({<RES = {'Y'}>} RecordID) / count(RecordID),Month) >= 0.83),Month))


      However its not working.  Any ideas?  83% is target.