We’re working on a new, extended expression syntax in v4.4 that is planned for release by the end of May. The changes:
Unary minus operator
It will be possible to use the unary minus. So instead of writing
addmonths([Date], 0 - 1)
it will be possible to write
Long due. I know
We’re introducing constants in expressions. Constants must be assigned using the
let operator before they can be used in expression. Syntax:
//Constant assignment. let a = ([A] + [B]) / [C] // Some complex expression //Use of constant in expression. ([D] + a) / ([E] - a)
Constants should help make expressions more readable. They also eliminate the need to create temporary columns in some cases.
Since the very early versions EasyMorph has been offering the if() function which works similarly to the IF() function in Excel.
Now, for better readability of expressions we’re adding the IF/THEN/ELSE operator, which is well known for Tableau users. Example:
IF isempty([FX Rate]) THEN error("Missing FX rate!") ELSE [Amount] * [FX Rate]
The ELSE statement is optional. If omitted it returns an empty value.
//If FX rate is empty the result will be empty too. IF not isempty([FX Rate]) THEN [Amount] * [FX Rate]
Question to our users: how do these improvements look to you?