user15995 Member

Comments

  • Nailed it. There were two blank values in the set that were being filtered out by my formula but not by your initial formula. Your modification allowed me to easily identify them. Thanks!
  • FYI - I attempted the first solution, and the results for a "true" condition were significantly higher than I would expect. Have you tried something similar with success? I also tried the second solution, and the results were also different from the calculation that I posted above. Not by much - there were two more values…
  • Thanks, I ended up breaking down the fields using ETL into major, minor, and patch versions. I should note too that most versions had a "-log" or something on the end, so they weren't super pretty. Here is what I ended up with: case when `mysql_major_version` > 5 then 'false' when `mysql_major_version` < 5 then 'true' when…