Mario Valdes II
- Total activity 22
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 6
- Subscriptions 4
Activity overview
Latest activity by Mario Valdes II-
Mario Valdes II commented,
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 ...
-
Mario Valdes II created a post,
Finding an average weekly count by year
Hello, everyone, I've got a workbook which contains the following data points: A list of roughly 8 shippers A list of roughly 800 destinations facilities A count of distinct pallet IDs shipped fro...
-
Mario Valdes II commented,
Yes, I think my issue is resolved, but thank you very much for your help and attention, Konsta!
-
Mario Valdes II commented,
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...
-
Mario Valdes II commented,
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...
-
Mario Valdes II created a post,
Help Diagnosing a Nested IF() Formula
AnsweredIf someone could help me diagnosis why the nested IF() formula below isn’t returning the expected result, I’d be grateful. I’ve got a date field (LATEST_PICKUP_DATE) wherein ‘null’ dates default to...
-
Mario Valdes II commented,
Good afternoon, Brian, Happy to report your solution appears to have worked! Thanks again!
-
Mario Valdes II commented,
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!!
-
Mario Valdes II created a post,
Adding "H:mm:ss" values in one field to a DATE field
AnsweredI’m sorry if the title is a little hard to follow; I’ll do my best to explain better: I’ve got two fields, a DATE field in the DATE format, i.e.: “Dec 27, 2019 12:00:00 AM”, and a TIME field in a S...
-
Mario Valdes II commented,
Thank you, Mr. Danyliuk! That worked perfectly!