moniP

ke I am Looks like I am hitting an syntax error ( (SUM(CASE WHEN (YEAR(`Date`)) = YEAR(CURRENT_DATE()) and WEEK('Date') = WEEK(CURDATE()) THEN `Revenue` ELSE 0 END)) - (SUM(CASE WHEN (DATE_FORMAT(`Date`,'%m/%d')) >= (DATE_FORMAT((CURRENT_DATE()),'%m/%d')) THEN 0 WHEN (YEAR(`Date`)) = (YEAR(CURRENT_DATE())-1) AND…

in YOY calculations Comment by moniP November 2016

I am interestedi n this too, however i see a 404 error on this page

in Excel text to column equivalent in magic ETL Comment by moniP May 2016

is it possible in date format to change it into a integer format eg: February 2016 is 1/2016 is that only possible in beast mode?

in Date Format Comment by moniP May 2016

I am also interested to know as well!

in Excel text to column equivalent in magic ETL Comment by moniP April 2016

moniP Member

Comments