Minimum

[Tatum1981]

Hello,

I am trying to get the minimum of a few different colums and need help writing the formula. Below is an example of what I need.  The first item I need 80,028 to be minimum.  The second item would have 951,237 as minimum.  The formula for Available Qty Nov is sum({<[Calendar Month]={'202111'}>} ([AVAILABLE QTY])).  Dec Available Qty is sum({<[Calendar Month]={'202112'}>} ([AVAILABLE QTY])).

Description	Minimum Available Qty	Available Qty Nov	Dec  Available Qty	Jan Available Qty	Feb Available Qty	March Available Qty
Item X		83,782	87,179	86,056	81,442	80,028
Item Y		951,237	1,033,062	1,110,682	1,126,857	1,390,276

[Vegar · Accepted solution]

You could get the min of multiple expressions by using the  rangemin(expression1,expression2,...,expressionN)

[Tatum1981]

Thank you ! The rangemin function worked!  I used rangemin and column numbers to get the minimums that I needed.