Q. Which mathematical operators can we use to build the Expression?
A. You can use any of the hundreds available in the math.js library.
Q. Its quite cumbersome to have to write the Expression by hand. Is there a GUI option?
A. 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.
Q. Can I include more than one operator in an Expression?
A. Yes, you can include as many operators as you wish in an Expression. Some users have written Expressions that contain 4 or more operators.
Q. Can I use the Calculated Column in other Queries?
A. Yes, once the Calculated Column is created, then its treated the same as any other column and can be used in Queries and Adaptable Blotter Objects.
Q. Can I edit a Calculated Column?
A. No, a Calculated Column is readonly. You can edit the Expression but cannot edit one of the cells in the column itself.