I have two data sets; one contains PO LN & the other contains Item; they both represent the same: a line on a PO; however, our vendor enters the lines different than we do sometimes. For instance, if our line is 10, they will either enter it as 10 OR 1, if our line is 330, they will enter it as 33, etc.
The rule I need goes as follow: if [PO LN] equals a number with digits different than 0, add a 0.
Case: If [PO LN] is 33, after formula, it will be 330.
