The calculation contains error
When I tried to create calculation field the Left([Period], 4) does not seen to be valid. It shows the caltulation contains error. Why is that? 
2 answers ( 0 marked as helpful)
Hi Matthew,
Please ensure the Period field is not a string (text) data type. The LEFT function works on string data types. If Period is a date or number, you will need to convert it to a string first.
Let me know if this works.
Best,
Ned
That worked. Thank you