Forum Discussion
Percentile exc measure
Hi, So I have a data set with columnns: Date&time; Attribute; kWh; and a few more I'm trying to calculate the Percentile exc percentile = PERCENTILE.EXC(data[kWh],0.99) In my data model I g...
Thank you Sahir_Maharaj
Re: I've applied the proposed formula and the result is still not as expected.
I suspect it relates to your comment: to "..... exclude blanks" from my data set.
My data do have some zeros in it. Please see an example below. The zero's are relevant for other analysis. Can I adjust the measure to exclude the zero values?
| Date&Time | Attribute | kWh |
| 17/03/2018 12:00 | WF1 | 200 |
| 17/03/2018 12:00 | WF2 | 0 |
| 14/06/2018 22:00 | WF1 | 415 |
| 14/06/2018 22:00 | WF2 | 218 |