Can we apply any logic in confluence data calculation?

Question

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??

Andrey Khaneev _StiltSoft_ · Answer

Hello Promantia,

Table Filter and Charts can do data calculations in tables:

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

Is it what you are looking for?

Shannon S · Answer

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