Results 1 to 10 of 10

Thread: Grid column totals

  1. #1
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,446

    Grid column totals

    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.

    Name:  Screen Shot 2014-06-02 at 4.41.12 PM.jpg
Views: 178
Size:  128.8 KB

    Name:  Screen Shot 2014-06-02 at 4.41.32 PM.jpg
Views: 165
Size:  126.6 KB
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  2. #2
    Senior Member
    Join Date
    Jan 2014
    Posts
    312
    Hi Barry

    Lianja just keeps getting better!

    Many thanks for the great new enhancement

    Thanks & Best Regards

  3. #3
    Lianja MVP
    Join Date
    Feb 2012
    Location
    Berea, KY, USA
    Posts
    1,858
    Fantastic: very useful.

    thanks,

    Hank

  4. #4
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,446
    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.

    Name:  Screen Shot 2014-06-03 at 2.05.03 PM.jpg
Views: 151
Size:  81.2 KB

    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.
    Last edited by barrymavin; 2014-06-03 at 03:12.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  5. #5
    Senior Member
    Join Date
    Feb 2012
    Location
    Rome - Italy
    Posts
    1,815
    Delicious...

  6. #6
    Junior Member
    Join Date
    Nov 2014
    Location
    Jakarta, Indonesia
    Posts
    8
    I found that total didn't work at 7 digits or above. any work around?

  7. #7
    Junior Member
    Join Date
    Nov 2014
    Location
    Jakarta, Indonesia
    Posts
    8
    ... i found it my self. i use currency(<column_name>) instead of currency({})

  8. #8
    Junior Member
    Join Date
    Nov 2014
    Location
    Jakarta, Indonesia
    Posts
    8
    wrong,
    using urrency(<column_name>) on Total Format only show active row value not the total

  9. #9
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,349
    Hi Amir,

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

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

    Regards,

    Yvonne

  10. #10
    Junior Member
    Join Date
    Nov 2014
    Location
    Jakarta, Indonesia
    Posts
    8
    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

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us