Daydiff function when not all rows have a date



1 comment

  • Avatar
    Sam Ovenshine (Edited )

    I'm not sure what the best strategy here is. But you can try a few things. First, IsNull to try to handle the nulls. Also, make sure your conditional statement follows the necessary structure:


    Finally, you could handle the nulls in the ElastiCube Manager by assigning them an arbitrary date (1/1/1900), then using a conditional statement or a script to hide the large DayDiff result values.

    Comment actions Permalink

Please sign in to leave a comment.