2 Replies Latest reply: Jun 27, 2018 9:26 AM by Jeremiah Bakerstull RSS

    Average Age by gender

    Jeremiah Bakerstull

      I'm trying to figure out who to write a formula for average age by gender type.

       

      I've tried: but the result is '-'

      =Avg( {$<[SVPPROFGENDER_entry] ='Female'>} Aggr(Avg(floor(Age('4/1/2018',[SVPPROFDOB_entry]))),[Client Id],[SVPPROFDOB_entry]))