Help Desk

Submit a ticket My Tickets
Welcome
Login

How to display numbers in their native form?

Question
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?

Answer
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: https://www.sqlite.org/printf.html.

If you need additional support, please contact support@onecloud.io.

Login to post a comment