Confluenceテーブルの通貨合計

[藤川 実]

Confluenceのテーブルに異なる通貨での支出を登録し、テーブルのフッターで合計金額を自動的に表示するケースです。

Confluenceのテーブルに通貨を設定し、フッターに合計金額を自動的に表示することはできますか？

[Mia Tamm]

Hi @藤川 実 

申し訳ありませんが、英語で回答させていただきます。

Confluence’s native table macro doesn’t support automatic currency totals in the footer. To get that functionality, you’ll need a marketplace app. There are several options. I will talk about one:

• Simple Table for Confluence

  1. Install the Simple Table macro.

  2. In your table settings, mark your “Amount” column as a currency field.

  3. Enable “Footer aggregation” → “Sum.”
     This will calculate and display the total of your currency column automatically. We have many currency types. Also ¥ is added.

Hope that helps!

— Mia Tamm from Simpleasyty

[Anwesha Pan (TCS)]

Hi @藤川 実 

Welcome to the Community! 🙂

If I understood your question correctly then you can follow the below steps to get the sum of the expenses in your table : 

How to create a table & display the total sum of the amounts in a column?

• Go to your Confluence Page

• Add macro table spreadsheet

• Add the data in your spreadsheet

• From the Toolbar at the top of the spreadsheet, change your Expense column format from Automatic to Currency

• To get the Total expense → click on the cell (after the last entry of your expenses column - highlighted in yellow color in this example) where you want to get the sum of your expenses

• From the Toolbar, click on SUM dropdown & choose SUM → Drag to select the cells of your Expense column → Hit ENTER

• Click on DONE & Publish your changes

Note: If you make any changes to the spreadsheet after it has been published, you will need to click on File → Save to save the spreadsheet.

Refer the below screenshot for example : 

I hope this helps 🙂

Thanks,

Anwesha