Leading zeroes in anaplan

Question

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 · Accepted Answer

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 · Accepted Answer

@JAbhi

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