Reset Continuous Serial Numbers using Rank formula from one Module to Another

Options
Ishan
Ishan Member, ALL USERS, Partner, Certified Master Anaplanner, Community Member, Certified Model Builder Posts: 5 Certified Master Anaplanner
in Extensibility

Dear Experts,

 

I basically want to Reset Serial Numbers in Ascending Order using Rank Formula from the last number (from one module) and start over with the next number (in another module), for example:-

 

In the "ABC" Module, I used the Rank formula:- TEXT(RANK(1, ASCENDING, SEQUENTIAL, Country = Country ZBB.US)) which ended up with the number 18236. Now, in the Module "XYZ", I want to start with the number 18237, please suggest how to reset it, the purpose of doing this is to Export data from both the Modules together into the third Module "123" where I have my non-Numbered List to pull and align the data from both the Modules.

 

Kindly share your expertise on how to do it.

 

Kind regards,

Ishan

Tagged:

Comments

  • Ishan
    Ishan Member, ALL USERS, Partner, Certified Master Anaplanner, Community Member, Certified Model Builder Posts: 5 Certified Master Anaplanner
    Thank you so much for the response Vinayvm!!
    But for MAX, we must need atleast 2 arguments (and we have just one, in this case), also Dimensions used in both the Modules are also different, please suggest!!

    Kind regards,
    Ishan

Categories