No announcement yet.

Totals not working

  • Filter
  • Time
  • Show
Clear All
new posts

  • Totals not working

    I have two grids with totals. One is a plain grid and the totals work just fine.
    The other one uses GroupBy and also displays Details on the same page (to the right).

    No matter what I do I cannot get total values displayed.

    Any ideas ? Is it a bug ?

  • #2
    OK, I did some more testing and I see that the moment I enable grid group by the totals disappear.
    This looks like a bug.


    • #3
      Hi, you can group it this way. a Checkbox for you field. group_by.JPG


      • #4
        OK, got it, thanks a lot, it works (although have issues with colors)

        Any idea how to get totals in a group calculated ?
        For example I have column A and B and I have totals summarized for both of them. I want to calculate

        BALANCE = A - B

        and place BALANCE in the same line where the group totals are

        Last edited by Frogie; 01-10-2019, 03:54 PM.


        • #5
          Hi, you can create a NEW FIELD type numeric (BALANCE), then in event ONRECORD you can make asign {BALACE} = {A} + {B};
          Then in GROUP BY option SELECT FIELDS, you can drag you new field.