debbie_a

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