Meta web calculated field syntax

Question

I'm searching for syntax in calculated field area (meta web or QBE). I'd like to extract year or month from a date, concatenate 2 strings and other classic data transformations. I work with MySQL and tried MySQL expressions improved with Workbench, but I've an error message each time. I tried to use predefined transformation proposed with buttons like <AA< or others, with or without brackets. Each time I have the error message : No columns using the name [] are found in the expression of Calculated Field.

Answer 1

Dear,

You can use these functions inside QBE Calculated filed.

E.G.: CONCAT(YEAR(The date),MONTH(The date)).

Best Regards

Angelo

Comments

Thanx Angelo,

I try with the YEAR function. It works for calculated fields in dataset but not in Business Model. I have the message : No columns using the name [YEAR] are found in the expression of Calculated Field [annee creation contrat apprentissage].

---

Another problem with calculated fields and CONCAT function, it works in dataset but if I add a function like COUNT DISTINCT I have an error in generated SQL