I am trying to use the formula tool to add a column/formula to count rows based on a key field.
Example using Restaurant Number as my key field.
Restaurant Number
123
456
456
456
789
789
New Column
0001
0001
0002
0003
0001
0002
Solved! Go to Solution.
Hi, @nihou
You can do a logic with the formula and the running total. Please see attached.
Or you could also do a logic with the multirow. I prefer the one above because is super simple and you can just remove the additional column with a select tool.
Please let me know if you need any additional help with this question.
Pedro.
Yes, thank you. How do I get it to count with an output of 0001 instead of 1, 0002 instead of 2, etc?
Thank you!
We can use a Padleft function in the formula tool
Please @nihou assign the answer as the solution for your post if we have answered your question. It really helps us.
Pedro.