Forum Discussion
Solved
getting one extra blank row in the data when using count
i have a table that shows : laundry name, order id, and rating id . for one laundry I'm getting one extra blank row for the rating , for example: one laundry has total orders =6 and total ratings =1...
FYI, there's also a function DISTINCTCOUNTNOBLANK.
using count instead of distinct count worked for me . distinct count considers the blank row however count doeant. will try to find out if theres any blank data also
FYI, there's also a function DISTINCTCOUNTNOBLANK.