Can we apply any logic in confluence data calculation?

Promantia September 18, 2019

Hi Team,

I have multiple number of rows , each time the raw numbers will be changed

see the example

No   Product name     quantity        Price       total

1          A                           10                2               20

2          B                            20                3               60

 

Net Total                                                                 80

 

 

* In this form can we able to create a template. Based on the inputs total and net total have to be displayed in the forms.The number of items will also vary in each forms. Is it possible to create template with this functionality??

 

* Is it possible to automatically generate sequence number whenever the user is creating a new form??

 

 

 

 

2 answers

2 votes
Andrey Khaneev _StiltSoft_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 20, 2019

Hello Promantia,

Table Filter and Charts can do data calculations in tables:

  1. Table Filter macro can output Total column and row.
  2. Pivot Table macro aggregates and calculates data.
  3. Table Transformer can perform complex calculations using formulas.

Is it what you are looking for?

0 votes
Shannon S
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
September 20, 2019

Hello Promantia,

Nice to hear from you again! 

While Confluence is not capable of making these calculations, you might also find an add-on for this functionality in Atlassian Marketplace as I mentioned in your other thread.

If you have any questions about any of the add-ons listed there, please let us know.

Regards,

Shannon

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events