Total of grid in integer

Total of grid in integer#795706

By avi123 - Mon Sep 25, 2017 10:15 am

- Mon Sep 25, 2017 10:15 am #795706

Hi,
I am facing a problem. In my process, I used a grid and applied SUM function on 2nd column.
See below image.

11111111.png (4.01 KiB) Viewed 4051 times

I want that total 1.00. how to solve this problem?

Thanks & Regards

Re: Total of grid in integer#795709

By amosbatto - Mon Sep 25, 2017 9:43 pm

- Mon Sep 25, 2017 9:43 pm #795709

Edit the file workflow/public_html/lib/pmdynaform/build/js/PMDynaform.js,

Change lines 8106 - 8111 from:

Code: Select all

                        if (operation) {
                            $(td).addClass("total");
                            icon = iconTotal[operation] ? iconTotal[operation] : iconTotal["other"];
                            label.innerHTML = icon + ": ";
                            result.value = title;

To:

Code: Select all

                        if (operation) {
                            $(td).addClass("total");
                            icon = iconTotal[operation] ? iconTotal[operation] : iconTotal["other"];
                            label.innerHTML = icon + ": ";
                            //Edit: Round to a fixed number of decimal digits
                            var decDigits = 2; //set the number of decimal digits
                            var rounder = Math.pow(10, decDigits);
                            title = (Math.round(title * rounder) / rounder).toFixed(decDigits);
                            //end edit
                            result.value = title;