Comments
-
Carter - thanks for the idea. Check out the solution from Goedipi, it worked really well!
-
Thanks Godeipi! This was the perfect solution.
-
Thanks! That totally worked I was counting on the wrong field...oops.
-
thank you!
-
@DaniBoy Thanks for the reply! I realized my mistake; not altering the size of the originating card for the publication group. I was looking at another copy. User error!
-
How would that apply in this equation? i'm getting errors when adding in additional case statements for each qtrs cal. case when `acct_wk_i` <= 13 then (`nonclr_sls`/ `avg_nonclr_sls_qtr1`)*100 when `acct_wk_i` > 13 and `acct_wk_i` <= 26 then (`nonclr_sls`/ `avg_nonclr_sls_qtr2`)*100 when `acct_wk_i` > 27 and `acct_wk_i`…
-
Thanks!! This worked perfectly.
-
Hi, This doesn't work, since I already have "when" in the calcs to determine acct_wk_i ranges. thanks for the idea.
-
After I found the bad data in a row, the to_date worked as the final step to convert the data type. thanks!
-
Thanks. After finding the bad data that in a row, the to_date worked as the final step to solve the conversion issue!
-
I did find some bad data, so you were correct on that call out!! thank you
-
Thank you for the confirmation! I won't submit an idea at this time since it's the first time I've had the question from a business partner.
-
Thank you! I'm glad to know it's in a new spot.
-
Thank you for this info! This will work great.
-
Ricardo, Thank you! I was hoping to avoid renaming in SQL, but I can certainly do so if that's the only option. Debbie