Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 142
  • Last Modified:

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),IF(TDMMYY="0916",(N2+O2+P2),IF(TDMMYY="1016",(N2+O2+P2+Q2))))

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
0
actsoft
Asked:
actsoft
  • 2
  • 2
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
= CASE(ddmmyy) WHEN '0816' THEN n2+o2 WHEN '0916' THEN N2+O2+P2 WHEN '1016' THEN  N2+O2+P2+Q2 ELSE 0 END
0
 
actsoftAuthor Commented:
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?
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
WHEN TTMMYY = '0816' THEN [0716]+[0816]
0
 
Scott PletcherSenior DBACommented:
CASE TDMMYY
    WHEN '0816' THEN [0716] + [0816]
    WHEN '0916' THEN [0716] + [0816] + [0916]
    WHEN '1016' THEN ...
    END AS TYSTD
0
 
actsoftAuthor Commented:
That worked with the addition of the full table and field name. thanks
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now