Use Case

You have a table or a macro outputting a table. 

You need to change the data format of the column containing numbers to add a dollar sign, a thousands separator into values and remove decimals.

Solution

  1. Switch the page to the edit mode.
  2. Insert the Table Transformer macro and paste the table within the macro body.
  3. Select the macro and click Edit.
  4. Switch to the SQL query tab.

  5. Enter the following SQL query:

    SELECT 'Company',
"$ "+FORMATNUMBER('Profit per month') as 'Profit'
FROM T*
    SQL
  6. Click Next.
  7. Define the table settings and view options. 
  8. Save the macro and the page.

FORMATNUMBER function allows you to format numbers according to the settings in the Table Transformer macro.

You can use FORMATWIKI function for the purposes of cell formatting.