I have a sheet called "main" with 4 columns like this :
I want to make a percentile of column N, with condition of column A, C, and J
I tried with function PERCENTILE(IF((x)*(y)*(z),aa),0.5)
and works for
queue_name = "idecbi-prod",
grass_week = "2022-09-05",
and task_user = "di_scheduler",
it works just fine with these conditions,
But when I tried to use another condition such as "idecbi-dev" or "ad-hoc" or another grass_week, it become error like this
Whereas the only thing i change is only O4 to O5 and N4 to N5
The data seems fine and we have all the conditions as shown in the first picture (main sheet).
Is there anything that I miss ?
Here's dummy data that I've created for better understanding.