About alexpavel

Sometimes in the numeric formatted cells, as a result of various calculations, it is possible to have returned as a result the Anaplan special numbers: Infinity, -Infinity, or NaN (Not a Number). If the numeric line item with this issue is also an input for other formulas, the final result could be altered. To solve this issue a solution is to convert these Anaplan special numbers in zero values. Convert Infinity and -Infinity: First thing is to have calculated the "Infinity" value in a system module without any lists. This can be achieved in different ways by applying one of the formulas in a numeric formatted line-item: DIVIDE(1,0) or VALUE("Infinity"). Then it can be applied, in sequence, to the following Anaplan functions: Convert numeric line-item in positive number (function: ABS). Compare the result in Step 1 if it is NOT equal with the Infinity value calculated in the system module If TRUE then consider the numeric value, ELSE consider 0 Example: IF ABS(Value num) <> 'SY00 Params'.'Val. Infinity' THEN Value num ELSE 0 Note: ABS function is useful to solve in one comparison both Infinity (positive) and -Infinity (negative) Convert NaN: Apply in sequence the following Anaplan functions/statements: Convert numeric line-item in positive number (function: ABS) Compare result Step 1 if it is greater or equal with zero. NaN value will return false. Consider the initial value of the line-item if Step 1 is greater or equal with zero else consider zero (on ELSE the NaN will be converted to zero). Example: IF ABS(Value num) >= 0 THEN Value num ELSE 0 Notes: - ABS function is useful to solve in one comparison both positive and negative numbers - NaN=NaN, NaN>=0, NaN<=0 comparisons will always return FALSE. This is why it is needed to check with zero the numeric values. ... View more

As a model builder, I would like to have the possibility to create an action with the option "Delete from List Using Selection" by using booleans line-items in combination with the Users List additional the List where it is needed to delete the elements. Currently, when trying to build an action "Delete from List Using Selection" are shown only the booleans line-item where the "apply to" contains only the List where the elements need to be deleted. It would be really helpful if the filter to delete elements from the list would accept also the combination of that List with the Users...this way a user can delete from a list based on a filter that is valid for "Current User". Users is a very particular quality: is the only list which in filtering has the option to apply the filter "Current User". Why not open the possibility to delete elements from a list based on a filter which is valid for the "Current User"? Use-case: Imagine a numbered list that has a line-item where is stored the "Users" and the user wants to delete all the elements of the numbered list which have values = with Current User logged in. Similar to this: What do you think? Alex. ... View more