Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]))
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]))
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]))
Thank you very much. Hope your day goes well.