Using MIN in formulate but only where > than another value
I am looking to create a box and whisper chart, I have got it working using Min / Max and average however we have a lot of Min entry where the value is 1 or 0, so the min is always near zero. Is it possible to say I want the min value where > x value
Trick here is to filter the list before applying the Min function.
Here's an example where I want to find the minimum value of sales for my products where the sales value is greater than a value, in this case, 6:
Gives the minimum in this list as 13.
If we were to just find the minimum value without the filter, we get 6:
Hope that helps.