micheleb Member

Ahh - thanks you - wrapping the total seconds in a sum seemed to do the trick.

I think the problem lies in that I am using page filter so the aggregation has to happen after the filtering happens. It's not individual records which is why the sec to time doesn't work. For example, users need to be able to use the page filters to select the specific cards they are interested in. In this case, after…

Thanks for your help ---- SEC TO TIME is converting the number of seconds (37,900) into a time 01:54:49 am. I have a whole number which is 37,900 seconds - this is the same as 10 hrs, 31 minutes and 49 seconds. I don't need a time value - I actually need a conversion of the # of seconds to what it would be in hours and…

thank you

I figured out what I was doing wrong - thanks for your help!

Still, get an error - I'm using the Add Formula in Magic ETL - so I'm guessing this process just doesn't work in Magic ETL. Thanks for your help

Hi, Thanks - I'm not sure how that would work I just get an error. I only need the value of Content Progress changed if the Journey-Pathway Content Progress = Completed; I don't want to create a second column.

.

The problem is the data in the column is not uniform so trying to use beast mode or changing data types won't work without changing the strings to consistent standard format won't work for a beast mode or simple data type change. Some strings are formatted 00/00/00 some strings are formatted 00/00/0000 some are null.

Thanks so much ! The Regex formula worked perfectly. I still had some folks who were hired in the 1900's but I'm thinking I could use a an If then statement like If Hire Date year is 2050 or greater to switch it to 1900's