we have Reporting plugin which enables to calculate the difference between two dates. Do you know how to achieve this? We don't find any docs for this.
We need the difference in days or month.
Thanks in advance,
If you are planning to write a plugin to do this, then you can have that plugin have a macro in it that takes two dates as parameters and calculates their difference. To calculate this difference , you can use the Joda API that already comes bundled within the confluence plugin package. More about this here : http://www.joda.org/joda-time/
For any calculations in Confluence, including calculations over tables, you may use CelesteCS Math for Confluence. There are versions for both Confluence Server and Confluence Cloud.
Assume you have a table with three rows and four columns: A till D with two rows and want to summarize elements from B2 to D2. Then here is the formula you should specify in A2:
If you want to calculate average value, use AVG function:
As you see, it is very simple and is similar to EXCEL with equal set of functions.
There is a plenty of other functions in the macro, so you may perform any calculations using formulas in EXCEL style.
Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time! We're looking for people to participate in a remote 1-hr workshop...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs