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%
Can you provide a few lines of what your data looks like?