avg score with null values

Comments

2 comments

  • Avatar
    Andrew Block

    Sivan,

    Here is a workaround let me know if this works for you

    Create an Average Score (AVG) field with the following CASE statement:

    Which would produce this:

  • Avatar
    Sisense Dev

    Hi Andrew,

    This doesn't work if the total score fields have no records as opposed to records with a blank. (hope that makes sense)
    Can you think of a way to capture missing values and do the same as you suggest for nulls? (or fill with 0)

    In my case there are millions of records so I'm reluctant to add dummy rows

    Thanks

    Jason

     

Please sign in to leave a comment.