kevin.cho
Certified Master Anaplanner

An alternative approach is below - here, we determine how many leading 0s we need to add, by comparing the number of digits in the original value, and comparing it against our "expected" format.

年代pecial note in Example 5, when the number of digits in value exceeds our expected length of the string (max 4 leading 0s). If this is not acceptable, then you will need to do further checks on the Value itself.

Example Leading 0s.png2022-04-30 14_34_47-Anaplan - POC and 2 more pages - Default Profile - Microsoft​ Edge.png