Retrieve dimension as line item
Hi,
I need to retrieve the selected dimension as a line item. For example, imagine I have a list with three items, Scenario 1, Scenario 2 and Scenario 3. What I need is some kind of function so that I can return the selected dimension, for example Scenario 1 in a line item.
Any help is appreciated, thanks a lot!
Best Answer
-
What you need here is a SUM equivalent for non numbers
For BOOLEANS you can use ANY (my favourite function), for Time Formatted, and List Formatted Line item FIRSTNONBLANK, or LASTNONBLANK can be used
This page is essential reading:
https://help.anaplan.com/anapedia/Content/Calculation_Functions/CF_Aggregation_Functions.html
See the following example:
Volia!
David
1
Answers
-
the function is called ITEM
https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/ITEM.html
Be aware though, that this will only need the dimension itself, so if you are needing to return the code, or name or checking for a specific item, DO NOT do this calculation in a multi-dimensional module. Do it in a module dimensioned purely by the list referred to in the ITEM(List) formula and then point subsequent line items to that; much more efficient for calculations
Also, try and avoid IF ITEM() =. Use boolean logic instead, this is more flexible
I hope this helps
David
0 -
Hi David,
Thanks a lot, this is what I needed!
Another question: I now have two modules, looking like the pictures below:
No dimensions, just 2 line items formatted as List and Time Period - Month
Two dimensions, Time and The same list as the "From"-line item in the picture above
What I ultimately want to do is to get the boolean checked if the month is selected in the "From Date" line item in the first picture, but I can't get that formula to work, since I cannot do a lookup on time. What I tried was something like IF owner=From [LOOKUP:From date] THEN TRUE ELSE FALSE
Do you have any suggestions on how to approach this issue? Thanks!
0 -
0
-
Excellent
Glad to help
David
0