I have calculated 90th percentile for a field (let’s say marks) in QS. I want to display only the rows that have marks greater than 90th percentile. I am trying to create a flag Ifelse(marks>P90_marks,1,0) → It is giving me “Mismatched Aggregation” error, saying customaaggregations can’t contain both aggregated and non aggregated field. Is there a work around for thus?
Hi @Manu,
Could you share the calculated field that you’re working with in this scenario?
Thank you!
Hi @Manu,
It’s been awhile since we last heard from you so following up to see if you had any additional questions or if you were able to find a work around for your case?
If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.
Thank you!
Hi @Manu,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.
Thank you!