Jump to content

Using Case with Time Periods and Function Errors

Dallas Dye 2

Recommended Posts

I'm trying to catagorize our days sales outstanding into different ranges( 1 - Priority, 2 - Medium, 3 - Low, 4 - Good) but i'm getting an error with the greater than or less than function.

DSO formula is Payment recived(Date & Time) minus End of Project (Date & Time), formatted into days example, 25.9


WHEN [DSO]>30 THEN "3 - Low"


Link to comment
Share on other sites

  • 2 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...