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
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.
You can add a line item "Minimum Expansion" with a formula
If Rank = 1 then Expansion else 0
Does it help?
Hi, I have a doubt in level 2 sprint 3.4.3 Activity: Create Country Summary Module I did the following :- Step 1 → Created a new column "Country Made in" in SYS08 SKU details Step 2 → Wrote a formula Parent(Supplied By) to bring parent of the location i.e. country in "Country Made in" column Step 3 → I have written the…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…
