I have a large raw data table and want to calculate the percentile of a group of records which meet a number of criteria (5 to be precise).
Example of what I've been trying (it's returning a value error):
=percentile(if(and(rawdata[criteriacolumnA]="this criteria", rawdata[criteriacolumnB]="this criteria"), rawdata[columnwithdataforpercentilecalculation], "") 0.025)
Any idea what I'm missing? Sorry for the sketchy example however I feel like the solution is something simple so I don't want to invest in making a sample notebook just yet.
Thanks in advance,
Max
Bookmarks