Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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
atlassian, loom, loom for training, loom for teaching, video training, async learning, online education, screen recording, loom tutorials, loom use cases, atlassian learning, team training tools, instructional video, virtual training tools

🛗 Elevate Your Training and Enablement with Loom

Join us June 26, 11am PT for a webinar with Atlassian Champion Robert Hean & Loom’s Brittany Soinski. Hear tips, stories, and get your burning questions answered. Learn how Loom makes training and enablement easier. Don’t miss it!

Register today
AUG Leaders

Atlassian Community Events