How to shift an item in line items

Hey, is it possible to get a value from column 1 to column 2, from column 2 to column 3 etc for Base Revenue. I would like to calculate base revenue for columns 2,3,4 etc. based on 1 column, but I don't know how to get the value from the previous column.
The target formula would look like this:
IF VALUE(NAME(ITEM('Number of Stores'))) = 1 THEN
21885929
ELSE
Previous Column (Base Revenue) * 0.9
Where lookin for formula is Previous Column which return value for previous column base revenue line item

Accepted answers

Prajjwal88

Hey @KacperSzafranski13, Functions like OFFSET, Previous or Lag won't work in this case as they are time based functions so they work with time as a dimension.

For this case, I can suggest you to create another lineitem which will item of lists in next position like 2 will have value as 1, 3 will have value as 2 and so on.

Note that the "Item" -Line item is numbered formatted one.
After then you can simply lookup the value based on this new line item.

All comments

umangsinghal

Hey @KacperSzafranski13, Create another lineitem and use offset function.

Formula example: OFFSET(Base Revenue, -1,0)

KacperSzafranski13

@umangsinghal thanks for your answer but OFFSET don't work for this example

OFFSET set value from FY22 not from previous column.

SriNitya

KacperSzafranski13
Hi Previous or Lag function will work for your scenario.

Prajjwal88

Note that the "Item" -Line item is numbered formatted one.
After then you can simply lookup the value based on this new line item.

Quick Links

Can you help?

Unanswered questions

Sorting General List
Hi, I wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…