Solved: Sequential Field - NOT KEY - Page 2

Luis_Gomes_Mac1 · 01-29-2020 05:13 AM

Hi again guys,

I am certain somebody have asked this question before, but I besides searching both on the community and Youtube I couldn’t found answer for it.

I need to create a sequential field for a a Quote Form I am building, such as:
PC301
PC302
PC303
etc…

It is important to say that this field will NOT BE A KEY as for indexation purposes, this is just for a presentation reason.

how and where do I build this expression?

LeventK

You can always read the last recorded value with a simple LOOKUP(…) expression, stripe the number part and then increment it by 1 and re-join,

CONCATENATE(
	"PC",
	NUMBER(
		INDEX(
			SPLIT(
				LOOKUP(
					MAX(Tablename[_RowNumber]),
					"Tablename",
					"_RowNumber",
					"InvoiceNumberColumn"
				),
				"PC"
			),2
		)
	) + 1
)

View solution in original post