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

Integration Process Execution Access - Which Access Takes Precedence?
We have an Integration Process in Anaplan CloudWorks created by User X - No WSA (originally Full Access with top-level Selective Access, now changed to Planner Read Only with Selective Access unchanged) and scheduled by User Y - with WSA , who also created the Integration Flow. Internal (Full Access) is enabled within the…
Anaplan XL Forms Error
Does anyone also get this error when opening the Forms in Anaplan FCR? I am downloading Investment Registry from the app but I cannot open it in Anaplan XL. How did you fix this issue?
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…