Mario Valdes II
- Total activity 22
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 6
- Subscriptions 4
Comments
Votes on activity by Mario Valdes II-
Yes, I think my issue is resolved, but thank you very much for your help and attention, Konsta!
-
In my data set, I’ve got the following fields: SHIPPER (Integer) DEST_FAC_NBR (Integer) CREATE_DATE (Date) LATEST_PICKUP_DATE (Date) LATEST_PICKUP_TIME (String) TEST (Integer, calculated field) LA...
-
Thanks for the response, Konsta! Yes, you've got the right idea, but I got my original formula to work by simply dropping the "does not equal" logic out altogether (in bold below.) My guess (and if...
-
Good afternoon, Brian, Happy to report your solution appears to have worked! Thanks again!
-
Thank you, Brian!! I won't be back to work until Monday, so can't try it until then, but thank you for the quick response; I'm sure it'll work!!
-
Thank you, Alan. It appears you are correct; I didn't know GROUPAVERAGE() was a thing as I mostly relied on getting my data into Excel for the more nuanced heavy-lifting, but it appears to work as ...
-
Thank you, Mr. Danyliuk! That worked perfectly!
-
Thanks, Mr. Forrester; your time and effort are much appreciated! Unfortunately, I'm currently on v7.1.12 and the TIMESTAMPDIFF function isn't available; I'll have to work with my boss to see if we...