Grid column totals

[barrymavin]

In v1.1.3 I have added in the ability to total grid columns as you navigate between data.

There is a new attribute in the section attributes "Summary".

You then specify what grid columns you want to be totaled.

[tekhong]

Hi Barry

Lianja just keeps getting better!

Many thanks for the great new enhancement

Thanks & Best Regards

[HankFay]

Fantastic: very useful.

thanks,

Hank

[barrymavin]

As I mention in the roadmap grids have had a major overhaul in v1.1.3...

"Added the ability to "Total" grid columns as a summary row at the bottom of grid sections. The "Summary" attribute in the grid section attributes can be checked on and then you can specify what columns should be totaled in the grid column attributes (double click on a grid column header). You can optionally specify an expression (a function call) that will be called to calculate the value to be displayed."

And when you theme it a little with CSS together with dynamic cell formatting and colors, you can produce something like this with NoCode.



This could of course also have hyperlinked fields in the grids that when clicked could switch the "DataView" to another page.

Also note that as you edit the data displayed in the grid cells the horizontal and vertical totals are automatically recalculated and re-displayed.

In v1.1.3 grid cells can also contain "Custom controls" so you can have a cell display a progress bar, a multi line form, an image or whatever else you need to wow your users.

Enjoy.

[phabio]

Delicious...

[amirmz@yahoo.com]

I found that total didn't work at 7 digits or above. any work around?

[amirmz@yahoo.com]

... i found it my self. i use currency(<column_name>) instead of currency({})

[amirmz@yahoo.com]

wrong,
using urrency(<column_name>) on Total Format only show active row value not the total

[yvonne.milne]

Hi Amir,

I think the only alternative would be to 'manually' calculate the total, e.g.

transform(sumvalues(quantity*unitprice),"$$,$$$,$$9.99")

Regards,

Yvonne

[amirmz@yahoo.com]

Hi Yvone,

thanks for the alternative, i submitted a ticket which you already passed for enhancement.

in the mean time, I use:

select sum(amount) from .... where .... into <variable>

to get the column total.

regards,
Amir