Hi Team,
Need help one below.
Please suggest.
I have a field with numbers and I need to concatenate number of zeros based on the number in that field.
Example:
Inputs:
Number | Decimals |
2 | 1 |
2 | 1 |
3 | 1 |
3 | 1 |
3 | 1 |
Output:
Number | Decimal |
2 | 100 (If 2 then 2 zeros to be appended) |
2 | 100 |
3 | 1000 |
3 | 1000 |
3 | 1000 |
Hey @PoliteGolite301991,
toString(Decimals)+Right("000000000000000000", [Number])
This formula should work.
Hi @PoliteGolite301991 a more scalable solution would be to use
PadRight(tostring([decimals]),length([decimals])+[number], “0”)
Apologies, edited after fat thumbing it