user07803

About

Username
user07803
Joined
Visits
0
Last Active
Roles
Member
Points
1
Badges
0

Comments

  • I gave that a shot and am still receiving the error from my previous reply.
  • I'm now receiving the below error: The database reported a syntax error. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CASE WHEN `Product Name` like '%YOUTUBE%' then 'YouTube' WHEN `Product Name` lik' at line 1 Code leveraged is below…
  • Thanks. I implemented your script and am now getting a divide by zero error. (SUM (Case when `Actual Revenue` = 0 then 0 when year(`Line Item Date`) = year(curdate()) then `Actual Revenue` else 0 end) - SUM (Case when `Actual Revenue` = 0 then 0 when year(`Line Item Date`) = year(curdate())-1 then `Actual Revenue` else 0…