Forum Discussion
lawada
Helper III
Helper IIIgetting 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.
lawadaHelper III
Helper IIIusing 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
AlexisOlson
Super User
Super UserFYI, there's also a function DISTINCTCOUNTNOBLANK.