I want to be able to define my parameter SA.FiscalWeek in the below code from a cell in Excel
SUM(CASE WHEN SA.FISCALYEAR = 2017
AND SA.FISCALWEEK = 19 THEN SA.SALESEXVAT/SA.EXCHANGERATEEURO END ) AS 'Week'
I will be using multiple Case When
in my overall code all with individual parameters
I have found a way this is possible using a WHERE
statement,
But was wondering if it is possible in a CASE WHEN
statement ?