Daydiff function when not all rows have a date

Answered

Comments

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:

    (Source: https://documentation.sisense.com/conditional-statements/)

    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.

    0
    Comment actions Permalink

Please sign in to leave a comment.