sequential numbering in line item

Jsdeloria21

Hi,

I would like to know how can we create a sequential numbering in a line item. I saw some post where they use RANK but it does not fit the requirement needed. 

 

In the module attached, I have a line item Transaction number where I want to show automatic numbering (1 - 100 for example) of the number of transactions. This will be used once it is imported to another model where there is a numbered list present. Is there a formula that will automatically show the numbers on the line item.

 

Thanks in advance

 

Regards,

 

 

Sequential_Numbering_44634.docx

BenHilgendorf

I'm not sure what post you were looking at, but I was able to use RANK to solve the problem. Steps are as follows:

 

(1) Create two new line items in TAT_HRApplications: Start Date of Month, Rank Grouping.

 

(2) Start Date of Month will be a Date-formatted line item with the formula START(ITEM(Time)). This will create a tie on transaction rows for a given month and applicant, allowing for a ranking based on a sequential tie-breaker. 

 

(3) Rank Grouping will be a List-formatted line item (where the List is your Applicants, shown in the source module's page selector) with the formula ITEM(*insert name of Applicants List here*). This will be used to "restart" the ranking for every applicant. 

 

(4) In your transaction count line item, enter the formula RANK(Start Date of Month, ASCENDING, SEQUENTIAL, TRUE, Rank Grouping). The second argument is arbitrary. 

 

(5) Map transaction count to your target module's list upon import.

 

Best practices tips: (1) The two new line items can be pared down to their respective dimensions (Start Date of Month only applies to Time, and Rank Grouping only applies to Applicants List) to reduce module size. (2) If these calculations have the potential to be used in other modules, I suggest splitting these out into modules and referencing them in your Applicants Module to avoid cluttering one module with multiple subsidiary views. From my understanding, subsidiary views decrease model performance (not to be confused with model size). 

 

Let me know if this works for you.