My numbers are being displayed like this 1.284621983e+07 and I need the number to show like this 12846219.83. How can this be accomplished?

To format the data with two decimal places thenUse the OneCloud Tabular Transformation BizApp Advanced Query Command. This Command leverages the SQLite engine which provides many formatting commands. To format your data, follow these steps:

  • Use the OneCloud Tabular Transformation BizApp and select the "Advanced Query" Command.

  • Enter the following syntax: SELECT PRINTF('%.2f',COL1) AS COL1 FROM data_table

For a full overview of formatting commands in the SQLite engine go to:

If you need additional support, please contact

Did this answer your question?