Alpha Numeral Generating Code

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
Answers
Questions
Solved3.16K viewsFormulas and Functions
0

Hi,
In the attached model, I am trying to create an automatic Alpha Numeral Job code matrix Budget.
The Alpha numeral consist of 1st three letters of department- 1st three letter of project and then a number.
The number for different months starts with 1 again how can I have a continuation of the number from the previous month for e.g for department System and Project name System :Datacenter the Jobcode ends with Sys-Data4. [u:1di9439x]I want the jobcode for November to start from Sys-Data5[/u:1di9439x].

Changed status to publish
0

In your formula, replace the Value(@Row) with #Month:Row.

Edited answer
0

See the Quantrix team’s explanation of this subject here:
Quantrix Ordering and Retrieving Conventions
http://www.quantrix.com/help_resources/6.4/webhelp/How_Quantrix_Accesses_Data.htm

Edited answer
0

Awesome! This works.
But could you please explain whats happening? what does #Month:Row do?
I # returns the position of the item.

Thanks