Hi ! I have a calculated field that returns for me a value that looks like 2021 | Q3 or 2022 | Q1, determining the year and the quarter from a payment date.
Now, in a linked table where this field (“Quarter”) is a lookup, I’m calling the RIGHT() function as follows :
RIGHT(Quarter,2) in order to have as a result Q3 or Q1 as in the examples above.
However, I get an ERROR!
I believe it has to do with the fact that my “String” is a lookup but even if I create a field in the table, a function, that is basically “Quarter” (i.e. take the value that’s in the lookup) and call RIGHT() on that new field, I get an ERROR! too.
I am deducting that RIGHT() cannot be called on a cell that’s a function ? True ? Any workaround ?
Thank you !