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

Finding Minimum

Hello All,

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

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

Regards,

Jeevan

You can use RANK()

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

Minimum can be found if rank = 1

You can use RANK()

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

Minimum can be found if rank = 1

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.

use minimum is ok

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

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

If Rank = 1 then Expansion else 0

Does it help?

403 error trying to access Support Portal
Hi - can't access support portal having already registered. Receive the following error message - is this an issue with Anaplan or our internal IT?
Hi Team , I am unable to login to the Anaplan portal using my credential.
Can someone help me i am unable to login anaplan portal using my credentials
Finding History for List Item Creation and changes
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to get…