Welcome, Guest. Please login or register.
Did you miss your activation email?

Author Topic: Counting only values that are not null (or 0)  (Read 311 times)

wattswhat

  • Newbie
  • *
  • Posts: 8
    • View Profile
Counting only values that are not null (or 0)
« on: March 20, 2023, 03:15:31 AM »
I am trying to count items in a databand that are not Null only.
COUNT() counts them all even the Null values.
How would I do this?

Arin Alex

  • Developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 992
    • View Profile
Re: Counting only values that are not null (or 0)
« Reply #1 on: April 19, 2023, 09:38:51 PM »
Hi, I will think about it.