It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to compute the percentage of an aggregate value in a TableView Merger? Edited

Hi,

The picture below is from a TableView Merger from a data table. I wanted to get the % Deductible from the total values (Deductible and Total Amount) = 67%. 

Using the Function:

* Percent:(CONCAT(ROUND((([entry.Deductible] / [entry.TotalAmount]) * 100),0),"%"))

It gave me the individual percentages from the original table.

 

Capture.JPG

 

Below is the source data tableCapture1.JPG

1 answer

Calculations in TableViewMerger are done per data row. The column calculating the % is concatenated from 3 calculations (as ConfiForms fails to recognise the value as numeric and concats it as strings)

Ok. Thank you Alex. I guess there is no way Confiforms can handle what i needed to get, either using TableViewMerger or anything within Confiforms.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

Lessons and Learnings: Six Months of Working Remote [Discussion]

Hey there, folks! For most of us, the past six months- yes, you read that right- have been a journey. More people than ever before have pivoted to working remotely, and navigating being on-scre...

8,466 views 6 6
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you