Beast mode formula

NIKKI
NIKKI Member
in Charting

if "event type" is not equals to "current physical due" but the the "enrollment date" is still within 90days from today then its consider as pending

and here is my formula: CASE
WHEN Event Type <> Current Physical Due AND ABS(DATEDIFF(NOW(), Enrolled Date)) < 90 THEN 'pending'
ELSE''
END

but it's not working, please help!

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    I would try breaking the two conditions out into separate conditions and see what they return. This will help you identify which part is the issue.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    I would try breaking the two conditions out into separate conditions and see what they return. This will help you identify which part is the issue.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • NIKKI
    NIKKI Member

    Thank you, I was able to figure the issue.

Categories