Add concat formula - Id Row
Hi, I have just implemented a formula to concatenate several columns of a table I have generated. Concat ( [Module],"_",[Type],"_",[Consecutive]) --> FI_R_001 The columne consecutive is a number of three characters like, 001, o 851. I would like to know, if it is possible instead of populating the consecutive column, use the row id that the table show me, and add one or two zeros depending on whether the row id has one digit or two. Anyone can help me?
Show less

