How do I count Not null values in beast mode

Sanket_ghavate87
Sanket_ghavate87 Member
edited April 2023 in Beast Mode

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

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    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!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    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