Hi you all!!!
I have a number field, and I want to increase one digit in the next record.
For example: if the last value in this field is 55400, the next was 55401
Thanks in advance for your help.
Use the MAX() function to get the current maximum value and then add 1 to it.
2 Likes
Hi !!!
Thank you for your help. IĀ“m trying the MAX function, but it returns the value 1
MAX(LIST([BOLETO]))+1
BOLETO is the field with the value, and the last is 520000. Should to return 520001
I dontĀ“t know if itĀ“s right.
Thanks again
Your expression inside of MAX() needs to return the list of valuesā¦ so something like:
MAX(Table Name[Boleto]) + 1
2 Likes
ThatĀ“s OK. If I test the expression, I get the right value, but not in the app (I always get the value 1)
MAX(Table Name[Boleto]) + 1
In this expression above you need to replace āTable Nameā with the actual name of the table that the column [Boleto] belongs to. I should have explained that in my previous post.
2 Likes
Hi Willow!!!
It works. Thank you very much!!
1 Like