Which mathematical operators can we use to build the Expression?
You can use any of the hundreds available in the math.js library.
Its quite cumbersome to have to write the Expression by hand. Is there a GUI option?
Not at present but it is on the To Do list and will be in a future release. We anticipate that you will be able to drag and drop the columns and choose the operators from a dropdown.
Can I include more than one operator in an Expression?
Yes, you can include as many operators as you wish in an Expression. Some users have written Expressions that contain 4 or more operators.
Can I use the Calculated Column in other Queries?
Yes, once the Calculated Column is created, then its treated the same as any other column and can be used in Queries and Adaptable Objects.
Can I edit a Calculated Column directly?
No, a Calculated Column is readonly. You can edit the Expression but cannot edit one of the cells in the column itself.
Can I create a Calculated Column that returns a string?
Yes, your Calculated Column can return a number, string, date or boolean. AdapTable will work out the datatype of the Calculated Column automatically, so that the created Column is treated like any other Column in queries and Expressions.
Can I change the name of a Calculated Column?
You can and the change will persist.
AdapTable will not update any layouts or other objects (e.g. filters) that reference this Calculated Column so be very careful before changing the name of a Calculated Column that is used elsewhere.