asked on need sql CASE statement to replace excel formula
I have a table with field names "0616" "0716" "0816" etc for 24 months. These fields contain numbers.
I also have a field that gets todays date and translates it to "0616" or "0716" etc.
I need a CASE statement to replace this excel formula.
=IF(TDMMYY="0816",(N2+O2),
I think it would start
CASE
WHEN 'TDMMYY' = '0816' THEN ...
what would the expression be to add the numbers from the fields named "0716" + "0816" + "0916"
please see attached sheet for screen shots that may make this clearer.
As always, Thanks you for your assistance.
case.docx
I also have a field that gets todays date and translates it to "0616" or "0716" etc.
I need a CASE statement to replace this excel formula.
=IF(TDMMYY="0816",(N2+O2),
I think it would start
CASE
WHEN 'TDMMYY' = '0816' THEN ...
what would the expression be to add the numbers from the fields named "0716" + "0816" + "0916"
please see attached sheet for screen shots that may make this clearer.
As always, Thanks you for your assistance.
case.docx
Microsoft SQL ServerDatabasesDB Reporting Tools
Last Comment
actsoft
= CASE(ddmmyy) WHEN '0816' THEN n2+o2 WHEN '0916' THEN N2+O2+P2 WHEN '1016' THEN N2+O2+P2+Q2 ELSE 0 END
ASKER
in the table the field names are not "n2" and "o2" they are "0716" and "0816".
so will
WHEN TTMMYY = '0816' THEN 0716+0816
add the amount in those fields together to get the total?
so will
WHEN TTMMYY = '0816' THEN 0716+0816
add the amount in those fields together to get the total?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
CASE TDMMYY
WHEN '0816' THEN [0716] + [0816]
WHEN '0916' THEN [0716] + [0816] + [0916]
WHEN '1016' THEN ...
END AS TYSTD
WHEN '0816' THEN [0716] + [0816]
WHEN '0916' THEN [0716] + [0816] + [0916]
WHEN '1016' THEN ...
END AS TYSTD
ASKER
That worked with the addition of the full table and field name. thanks