FlexGridSubtotal count not working

FlexGridSubtotal count not working

Posted by: michal.dziubek on 31 August 2022, 6:18 am EST

• 

  michal.dziubek

  • Post Options:
  • Link
    Copy

  Posted 31 August 2022, 6:18 am EST - Updated 29 September 2022, 11: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?

• 

  jimmy.wick90

  • Post Options:
  • Link
    Copy

  Posted 19 April 2023, 4:03 am 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