Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm concatenating a value - with the business rule if the length is greater than three characters, then place a decimal point in the middle, then concatenate the remaining text. Below is my formula
=IF(LEN([code] > 3),concat(mid([code],3,1))&'.'&concat(mid([code],4,5)),
)
The Expression is 'OK', but I get an \\Error in Calculation as a result. What am I missing?
Thanks in advance
You closing parentheses for the LEN function should be after