How to subtract two columns of a table and create a extra column which holds the values?

Question

Hi....I am new to Creating charts and tables with confluence.

I am using Table transformer macro. In a page I created the macro by typing {table transformer} inside the macro I pasted my table which looks like this

And then I am going to Edit mode of Table Transformer and Clicking on Custom transformation in Presets and in SQL i see SELECT * FROM T*

What I wanted to do is, create a Column in addition to the existing table as 'Remaining' which is 'Total' - 'Finished'.

How should i write an SQL Query to do this?

Kindly help me with this.

Andrey Khaneev _StiltSoft_ · Accepted Answer

Hi Priya,

The query is

SELECT *, 'Total' - 'Finished' AS 'Remaining' FROM T*