Search for answers here or ask a question
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

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Ian MacdonaldAdmin
    • Team Lead - Product Management
    • Ian_Macdonald
    • 1 mth 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 

    Like 2
Like Follow
  • Status Answered
  • 1 mth agoLast active
  • 1Replies
  • 19Views
  • 3 Following