Calculated Fields - Limitation no.1
Just a quick one, I've started to use calculated fields more and more and came across a new restriction the other day.
Problem
You can't reference a lookup field type in concatenation. You will get a error "You can't set the value country, which is of type lookup, to type string." Shame i would have thought Dynamics would have been able to handle this by now.
Solution
The solution for me, was luckily i had a workflow that was firing on create already so i just popped a statement into it to write the lookup value out to a new text field. Then tweeked the calculated field.
