I vote for this idea. We recently had a need to bring up an archived of production copy online to investigate moving numbers in the live production model. However, the production workspace is not big enough to hold both models. With this ability, we can import the model to another workspace.
... View more
Paul, I have needed to find a MODE for a couple models now. The way I have been calculating the Mode is by turning the numbers into a text string concatenated with the dimensions that I need to find the mode across. i.e. Find the Mode of a Price by Product, by Territory. Step 1: Load File with unique ID name KEY ID Step 2: Concatenate Product&Territory&Text(Price) Step 3: Firstoccurence(Product&Territory&Text(Price), KEY ID) Step 4: Import concatenation of Product&Territory&Text(Price) into a new list name Mode List Step 5 Mode List Finditem: Finditem(Product&Territory&Text(Price), Mode List) Step 6: Add a line item with Formula = 1 and name it Count Step 7: Final Mode: Count[Sum: Mode List] Step 8: Run a Max Formula on Final Mode by Product by Territory Step 9: If Max = Final Mode then Sum Price by Product by Territory I understand that this takes a couple steps to run the mode, let me know if you have a simple method to run a mode across multiple dimensions! Thanks! Morgan
... View more