-
Re: Avoid creating duplicate items in list when importing from a versioned module
@klameer - The line item Emp+Amount used in the RANK function ranks each individual unique combination of employee and amount across multiple versions. SEQUENTIAL in RANK function will make sure if t…1 -
Re: Rank by Student Names (alphabetic order)
@Sachinsourav02, Use this formula, and it will give sequential ranking to employees: RANK(1, DESCENDING, SEQUENTIAL, TRUE)1 -
Re: Rank by Student Names (alphabetic order)
@Sachinsourav02 - It's a good use case and I am still thinking how we can rank Employees as per their Name alphabetically. But I saw your primary reason for using rank, I would say since you wan…1 -
Re: How do you import line items from one specific list in a module?
@ShakirHabib, Create a new line item and write an IF ELSE condition like: Calc Cost: IF Dept = "CTO" OR Dept = "CIO" OR Dept = "HWPO" THEN Cost ELSE 0 Then use SELECT fu…1 -
Re: January 2024 Community Q&A Challenge — join the discussion and collect a badge!
My list of top Anaplan features for 2023: Freeze Panes: Freeze up to any row or column in a grid or worksheet. Allowing for easier analysis and navigation through large data sets. Anaplan end users c…9

