Finding Minimum

JEEVAK
JEEVAK
in Modeling

Hello All,

Here I need to find Minimum of values in Expansion. But I dont need zero to be minimum.

ExistingExpansion
140
1618
1820
2022
2224
340
14000
00

 Please help in finding the minimum. Suggest the function for the same.

 

Regards,

Jeevan 

Tagged:

Best Answer

  • Ivan_Lo_
    Ivan_Lo_
    Answer ✓

    You can use RANK()

     

    e.g. Rank = RANK(Expansion, ASCENDING, , Expansion > 0)

     

    Minimum can be found if  rank = 1

Answers

  • sobaid
    sobaid

    Hi @Ivan_Lo_ are we missing anything in between the commas, I tried this, the formula is invalid.

    Do we need more argument there (Minimum, maximum, average), I tried with Minimum.

  • Ivan_Lo_
    Ivan_Lo_
    use minimum is ok
  • JEEVAK
    JEEVAK
    But I need that minimum value to flow into other module....
  • Ivan_Lo_
    Ivan_Lo_

    You can add a line item "Minimum Expansion" with a formula

     

    If Rank = 1 then Expansion else 0

     

    Does it help?

     

     

Categories