0

Using MIN in formulate but only where > than another value

HI

 

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

 

Thanks

 

Nick

1 reply

null
    • Senior Director of Product
    • Ian_Macdonald
    • 1 yr ago
    • Reported - view

    hi Nick,

    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.

    Ian 

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 1Replies
  • 35Views
  • 3 Following