FlexGridSubtotal count not working

Posted by: michal.dziubek on 30 August 2022, 9:18 pm EST

  • Posted 30 August 2022, 9:18 pm EST - Updated 29 September 2022, 2:45 am EST

    After load data from mdb file, i preperare view for user.

    I discoverd then, when I use count on col without values, grid don’t work properly

    f.subtotal flexSTSum, -1, 7, , 16767927, , True, " "
    f.subtotal flexSTCount, -1, 12, , 16767927, , True, " "
    f.subtotal flexSTCount, 1, 12, , 16767927, , True, " "
    f.subtotal flexSTCount, 2, 12, , 16767927, , True, " "
    f.subtotal flexSTCount, -1, 14, , 16767927, , True, " "
    f.subtotal flexSTCount, 1, 14, , 16767927, , True, " "
    f.subtotal flexSTCount, 2, 14, , 16767927, , True, " "
    

    How to fix it?

  • Posted 18 April 2023, 7:03 pm EST

    You could try a COUNTIF.

    =COUNTIF(D2:D23,“Filled”)

    Edit: And I just tested Subtotal with a copy of your D column and it worked just fine? Are the remaining cells truly blank?

    Edit 2: Check the empty cells for spaces as they will alter the count on SUBTOTAL.

    Last

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels