Design a line item with a sequential numbers in it

Mahdiyar · 2024-03-15T15:44:11+00:00

There was an error rendering this rich post.

Hello everyone. I hope you are doing well. I was wondering if someone could help me to design a line item in a module dimensioned by time which generates these numbers from the first column to the end column. The order of numbers and the numbers themselves are as below :

1,2,2,3,3,3,4,4,4,4, 5,5,5,5,5 and so one ( it should continue till the end column )

Thank you everyone

Accepted answers

Dikshant

Great, so we can use the next function to refer to the same line item. Usually it gives circular references, but it's good to know that's not the case with the next function.

All comments

Dikshant

Hey, Interesting problem statement, and I got a solution. So, this is an example of arithmetic progression and there is a formula to calculate the the end term of a number if you see the pattern closely. So let's say

1 will end on 1st term

2 will end on 3rd term

3 will end on 6th term

4 will end on 10th term

Formula to calculate the end term of a number (n) is n(n+1) /2

We can create a list called Sequence and add a few items in it and we can calculate it's corresponding end term in the system module.

Sequence List

SYS Sequence Details

This must be your main module with time dimension.

We have sequence line item which will give you sequence of 1,2,3 across months. Using find item we convert the sequence to Sequence list format. And then lookup the End Term of each sequence.

Using post function, I pushed the values to the end term.

Now a final transformation to fill in the next available values to the months which is showing zero in Post Line item. Here is the formula:

I was not able to come up with the best way of writing this in such short time.. But in order to get to a solution, just nested it in a same formula. So I keep it up to you/ community members to find alternatives to get this final calculation in better ways.

Hope this helps!

Mahdiyar

@Dikshant Wow, Awesome

SriNitya

@Dikshant Extraordinary !

Mahdiyar

@Dikshant Hi . Just one tiny change to your final Calculation ( instead of IF )

Dikshant

Great, so we can use the next function to refer to the same line item. Usually it gives circular references, but it's good to know that's not the case with the next function.

Quick Links

Can you help?

Unanswered questions

Curious Comparison: Forecast Modeling for Unusual Products
I've been experimenting with some forecast modeling techniques in Anaplan recently and decided to test them on a few quirky, offbeat product categories just for fun. One of the categories I played around with was love dolls—yes, you read that right. It actually turned out to be more interesting than expected. Unlike…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
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.…