I'm trying to return the vendor lead time (for example 8M) but I only want to display the 8 so that I can do calculations off of it. I know in excel it's Left(cell,1) but I don't know how to do this in Jet yet.
Currently have the below in the cell to return the value.
=LinkField([Vendor],[Lead Time Calculation])
Date
Votes
1 comment
-
Jet Reports Historic Posts If there will only be a single digit as the first character of that string, you can still use the LEFT function.
In the Table Builder, simply click on "+ Add Formula" to add in your LEFT function (using [@[field]] notation to identify the field you want to work with)…
If the lead time can be longer than a single digit, the method is the same… but the formula gets more complex - since you need to figure out how many characters are in numeric portion.
Please sign in to leave a comment.