Last answered:

25 Sept 2024

Posted on:

01 Dec 2023

0

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)
Instructor
Posted on:

04 Dec 2023

0

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
 

Posted on:

25 Sept 2024

0
That worked. Thank you

Submit an answer