How do I count Not null values in beast mode

Sanket_ghavate87
Sanket_ghavate87 ⚪️
in Data Platform & Data Science

we do have function in SQL as name is not Null , Do we have similar function in DOMO beast mode?

Answers

  • Sanket_ghavate87
    Sanket_ghavate87 ⚪️


  • GrantSmith
    GrantSmith Indiana 🥷

    COUNT function will count the number of non null records

    if you’re wanting to compare to not NULL then it’s the same as SQL

    CASE WHEN `Name` IS NOT NULL THEN 'Not Null' ELSE 'Null' END
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories