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
Hello @Pham Ngoc Tuong ,
I believe you use Table Transformer of our Table Filter, Charts & Spreadsheets app.
Please confirm that my understanding is correct:
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
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
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
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
Hi Alexey!
perfect, now i can work follow your guideline, Thanks you so much
It looks like you're new here. Sign in or register to get started.
