Leading zeroes in anaplan

JAbhi

I want to fix the length by appending zeroes :-
Consider below example where i am having 3 Prod ID :-
1234
1234567
123

Below is the result i am expecting:-
0000001234
0001234567
0000000123

Generally we call this left/right padding or leading zeroes.

Prajjwal88

Hey @JAbhi ,

You can simply do this by applying one Right function in the other line Item as:

Right("00000000"&Text(Line Item),10)

I hope this helps.

rob_marshall

@JAbhi

The correct answer is @Prajjwal Jar answer, as there is no need for a long IF THEN ELSE statement.

umangsinghal

Hi @JAbhi , Hope this helps!

JAbhi

Thanks @Prajjwal88 & @rob_marshall, this worked.

It was quite simple, i should i have explored it on my own, but i was searching for some particular keywords :)