1 Reply Latest reply on Oct 8, 2013 12:18 PM by Alex Kerin

    How can I get the minimum of two measures? e.j. The minimum value between inventory and sales.

    Carlos Quevedo

      How can I get the minimum of two measures? e.j. The minimum value between inventory and sales.

      I tried with formula MIN, IF and variants but seems not to work.

       

      thank you,

       

      RQ

       

      Additional information: What I am trying to achieve is to perform a calculation where Tableau can identify which measure has the lower value between Sales and Inventory, and use the result for a calculation.


      e.g. Sales 100, Avg Inv (50) then use the result to calculate the fill rate as a % of sales, 50/100 = 50%