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?
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…
I've been experimenting with some forecast modeling techniques in Anaplan recently and decided to test them on a few quirky, offbeat product categories just for fun. One of the categories I played around with was love dolls—yes, you read that right. It actually turned out to be more interesting than expected. Unlike…
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled