Calculation number in table

[Pham Ngoc Tuong]

I have a Table with 4 column and numeric date in that 4 column, then i want calcuation and make 5th column with formular :

value column 4 - (value column 3+Value column 2+ value column 1)

how i can do it in table transformer, pls help

[Alexey Mikhaylov _Stiltsoft_ · Accepted solution]

Hello @Pham Ngoc Tuong ,

I believe you use Table Transformer of our Table Filter, Charts & Spreadsheets app.

Please confirm that my understanding is correct:

• value column 4 has dates
• value column 3, Value column 2, value column 1 all have simple numbers (which are days for the purposes of your calculation)

[Pham Ngoc Tuong]

Hi Alexey, yes, i'm using table transformer for calculation

all 4 column are simple number, base i was convert date diff from other column to column 1 to 4. so now, i want calculate GAP beet ween them

[Alexey Mikhaylov _Stiltsoft_]

Hello @Pham Ngoc Tuong ,

Based on the described case, please try this simple SQL query:

SELECT 

T1.'value column 4' - (T1.'value column 3' + T1.'Value column 2. + T1.'value column 1') AS 'value column 5'

FROM T1

[Pham Ngoc Tuong]

Hi Alexey!

perfect, now i can work follow your guideline, Thanks you so much

[Vronik]

Hi

Look at this, maybe can help you

https://community.atlassian.com/forums/Confluence-questions/Table-Transformer-Macro-custom-SQL/qaq-p/2284731

https://marketplace.atlassian.com/apps/1219300/sql-powered-table-transformer?tab=overview&hosting=server

https://community.atlassian.com/forums/Confluence-questions/Table-transformer/qaq-p/2919936

https://community.atlassian.com/forums/Confluence-questions/Using-Table-Transformer-SQL-to-summarize-totals-from-table/qaq-p/2313593

Regards

[Pham Ngoc Tuong]

Hi Vronik!
thanks for your feedback, but i still not find out how is solution for my case, could you help to check and give me details solution for my case, 

2nd link only show for sum of row, but i need base on 4 column with numeric format, i can make a fomular for summary and minus also folllowing is : 

value column 4 - (value column 3+Value column 2+ value column 1) as new column data