Hello.

I have a Table titled "Raw Data". There are two columns in this table, Category and Sales. I want to calculate the 25th percentile of a specific ID only where sales is >0.

I have the following:

=PERCENTILE.INC(IF(AND(RawData[SALES]>0,RawData[Category]=A4),RawData[t52w_ops]),H3)

Where A4 = unique category and H3 = 0.25

This formula consistently returns 0. If I remove the AND statement and only calculate based on category, it works fine, but includes the 0's. I cannot delete the 0 rows from my dataset. Any help is appreciated. Thanks!