. How do I get signed up for the Thirty Thursday Webinars? I would really love to participate. Thanks!!
Kris
Twin Cities Girly Geeks
. How do I get signed up for the Thirty Thursday Webinars? I would really love to participate. Thanks!!
Kris
Twin Cities Girly Geeks
Hi Melissa,
Can you post a screenshot of the record that triggered the error you posted? I created a Formula(DateTime) field and used your Formula and can't get the error to trigger
IF (
CASE (
MOD ( DATEVALUE ( DateTime_1__c ) - DATE ( 1900, 1, 8 ) , 7 ) ,
0 , 1 ,
1 , 1 ,
2 , 1 ,
3 , 1 ,
4 , 1 ,
5 , 0 ,
0
) = 0 ,
DATETIMEVALUE ( TEXT ( DATEVALUE ( DateTime_1__c ) ) & ' 23:00:00' ) +
CASE (
MOD ( DATEVALUE ( DateTime_1__c ) - DATE( 1900, 1, 8 ) , 7 ) ,
0, 1,
1, 1,
2, 1,
3, 1,
4, 3,
5, 2,
1
) ,
DateTime_1__c +
CASE (
MOD ( DATEVALUE ( DateTime_1__c ) - DATE( 1900, 1, 8 ) , 7 ) ,
0, 1,
1, 1,
2, 1,
3, 1,
4, 3,
5, 2,
1
)
)
Happy Monday all - I've been asked to do some reporting on cases that will tell us the percentage of total cases a user has closed within x days.
For example if I have closed 30 cases, 15 within 1 day, 10 within 2 days and 5 within 3 days, the report would so 50% of my cases close in 1 day, 33% for 2 days and 17% for 3 days.
I'm most likely over-looking something...I believe I've run a report like this before...?

!
https://mobile.twitter.com/search?q=%23Snowforce&s=tyah#MWD15