topic AutoNumber 1-4 in App Development

AutoNumber 1-4

fosterma — Wed, 02 Oct 2019 12:51:08 GMT

Hello, hopefully a quick one

I have a range of values that I want to autonumber from 1-4 in sequence, without a dimension to group the values.

For Example:
1111,1
1112.2
1113,3
1114,4
1115,1
1116,2
1117,3
1118,4
1119,1

Re: AutoNumber 1-4

treysmithdev — Wed, 02 Oct 2019 16:08:11 GMT

Would something like this fit your use case?

data: Load RowNo() as Row, Id, Replace(Mod(RowNo(),4),'0','4') as FormulaA, Mod(RowNo()-1,4)+1 as FormulaB, Goal Inline [ Id, Goal 1111,1 1112,2 1113,3 1114,4 1115,1 1116,2 1117,3 1118,4 1119,1 ];

Output:

Re: AutoNumber 1-4

fosterma — Fri, 04 Oct 2019 13:37:37 GMT

Perfect Thanks @treysmithdev