Сorrespondence of a number to a numerical interval from the List
How can I match a numeric interval from the List to a number in Anaplan?
For example:
Interval list:
1 - [name: "<=80"] (min = 0, max = 80)
2 - [name: "80-90"] (min = 80, max = 90)
3 - [name: ">90"] (min = 90, max = 1000)
Number = 83,257 - it should correspond to the interval No. 2 "80-90"
Best Answer
-
Here is the solution to achieve this requirement:
I am taking an example where for all employee users are entering a budget and we need to calculate the range of the entered Budget.
1) Create a Interval List and and the items as shown in the screenshot along with 2 numeric properties Min and Max.
Note: Make sure to add a Top Level item called Top (Very Imp)
2) Create a Input Module for Employees and add 2 line items Budget(Number) and Interval(List: Interval List)
3) Create a Calculation Module and add 2 line items Valid(Boolean) and Valid Interval(List: Interval List)
Formulas:
Let me know if you have any questions.
2
Answers
-
Great question! I would like to point you to this resource:
Let me know if that does not work for you!
0 -
Thank you very much!
This works out perfectly.
0 -
The way you did is correct, just put the MIN/MAX values in a SYS module and not list properties. Why? They are easier to change if the tiering changes in the future.
0 -
@rob_marshall That's right, I just created properties to save time 😊 but yes, using system module is ideal way always to store such values and not list properties.
0
