Comments
-
@DavidChurchman Thanks for the reply! When you say wrap the 8s and 10s, what do you mean by that? Also, I've tried doing COUNT(unique identifier) * SUM(shift length) in the analyzer and it did not fix my problem, but the ETL editor won't let me wrap my case statement in a SUM(). I'm getting stuck on how/when that…