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

Question

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.

Below is the source data table

Alex Medved _ConfiForms_ · Answer

Not with built-in ConfiForms macros, no. But you can always have a small script utilizing the ConfiForms REST API and calculate whatever you need.

For example

https://wiki.vertuna.com/display/TEST/Averages%2C+totals%2C+sums+and+standard+deviation+calculation

And your case:

https://wiki.vertuna.com/display/TEST/Using+ConfiForms+REST+API+and+JavaScript+to+calculate+totals+and+percentage

Joel Tabares · Answer

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.

Alex Medved _ConfiForms_ · 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)