user07803 Member

Comments

  • I gave that a shot and am still receiving the error from my previous reply.
    in Adding a field with mySQL Comment by user07803 August 2018
  • 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…
    in Adding a field with mySQL Comment by user07803 August 2018
  • 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…
    in YoY Beast Mode Issue - "Issue Occurred While Processing" Comment by user07803 June 2018
Default Avatar