Dallas Dye 2 Posted February 13, 2020 Share Posted February 13, 2020 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 case WHEN [DSO]>30 THEN "3 - Low" WHEN [DSO] Link to comment Share on other sites More sharing options...
Khushboo Rabadia Posted February 21, 2020 Share Posted February 21, 2020 You can change your DSO column expression to calculate date diff i.e.DateDiff("dd",[Year],DateTimeNow()) which will give days in real format and hence, case when would not error out. Currently just doing minus with datetime column results in timespan format of DSO column so it is failing in your case expression Link to comment Share on other sites More sharing options...
Dallas Dye 2 Posted February 22, 2020 Author Share Posted February 22, 2020 This worked perfectly Khushboo! thank you for your time! Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now