Omni supports 1:1 excel syntax in writing table calculations. [1] There may be cases where some formulas displays an error due to syntax or other limitations on query structure.
Generally more info regarding that calculation error can be found in the SQL editor as a comment. This can be helpful to unblock errors when writing table calculations.
