Confluenceテーブルの通貨合計

[藤川 実]

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

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

[Roma Bubyakin _Wombats Corp_]

Hello 藤川 実,,

We have developed a powerful app to create custom macros for any needs:
User Macro for Confluence Cloud

Using it, I have created a macro that transforms your table in a desired way and calculates the multi-currency sum. Here is how it looks:

It's already available in our public Library of examples: Multi-currency Table Sum

It means you can add it as-is or even customize it further to suit your needs.

The User Macro app offers extensive options for custom logic, integrations, and data presentation. Let me know if you need any other custom display formats.

Regards,
Roman, CEO of Wombats Corp

---

こんにちは 藤川 実,,
私たちは、あらゆるニーズに対応したカスタムマクロを作成するための強力なアプリを開発しました:
User Macro for Confluence Cloud
このアプリを使用すると、テーブルを任意の形式に変換し、多通貨合計を計算するマクロを作成できます。以下がその例です:
このマクロは、当社の公開例ライブラリで既に利用可能です：Multi-currency Table Sum
これにより、そのまま追加したり、さらにカスタマイズしてご要望に合わせて調整することも可能です。
User Macroアプリは、カスタムロジック、統合機能、データ表示の幅広いオプションを提供しています。他のカスタム表示形式が必要な場合は、お気軽に連絡ください。
敬具,
Roman, CEO of Wombats Corp

[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