3 Replies Latest reply on Oct 25, 2016 3:27 AM by Ankit Agarwal

    Non Zero values using MIN/any other function?

    Talha Valam

      Hi everyone,

       

      Quick question and I thought this would be a simple MIN calculation or a variation of it.

       

      I want to find the minimum selling price of a product across my view. Occasionally, there are issues in my data source where there is a 0.00 in the price field. The MIN formula will pick that up and display it, even though that's not what I meant. I'm looking for the minimum NON ZERO value.

       

      I know in excel, using a SMALL and a COUNTIF formula can get me what I need, but how would I produce that result in Tableau?

       

      I looked through the forums and found something similar to my request, but not exactly what I needed.

       

      Appreciate all the help everyone!