Hello All, Here I need to find Minimum of values in Expansion. But I dont need zero to be minimum. ExistingExpansion14016181820202222243401400000 Please help in finding the minimum. Suggest the function for the same. Regards, Jeevan

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Finding Minimum

JEEVAK

Hello All,

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

Existing	Expansion
14	0
16	18
18	20
20	22
22	24
34	0
1400	0
0	0

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

Regards,

Jeevan

Accepted answers

Ivan_Lo_

You can use RANK()

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

Minimum can be found if rank = 1

All comments

Ivan_Lo_

You can use RANK()

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

Minimum can be found if rank = 1

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_

use minimum is ok

JEEVAK

But I need that minimum value to flow into other module....

Ivan_Lo_

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

If Rank = 1 then Expansion else 0

Does it help?

Quick Links

Can you help?

Unanswered questions

Connection Problem with Excel Add-In Series 4 - No Customer
Hello everyone, I hope you're doing well. I'm posting because two of my coworkers are trying to use the Anaplan Excel Add-In Series 4, but they're running into an issue during the connection setup process. When they go to New → New Read-Only Connection (or New Connection) and reach the "Select a Customer" step, no…
explainability results is blank into model
Why in my model output is blank, after send explainability data.
How can I use the RANK function with composite hierarchies where parent items can't be concatenated?
I am working on a use case where I need to display the top 5 lines of a module as individual lines, while grouping all remaining lines under an "Others" category. The module is dimensioned by multiple composite hierarchy lists, along with Time and Version. To achieve this, I need to use the RANK function with the Ranking…