Average Age by gender

[jbakerstull]

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]))

[sunny_talwar · Accepted solution]

May be this... but is this only needed for Female?

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

[jbakerstull]

Thank you very much. Hope your day goes well.