Nested CASE in formula?

[celauritz]

Is something like this possible? Basically, every formula either returns a 1 or a 0, but it only reads down to "Cable/Internet" and then everything else comes as a blank value.

SELECT {@CABLE}
CASE 1 :
SELECT {@INTERNET}
CASE 1 :
SELECT {@PHONE}
CASE 1: "THREE PLAY"
CASE 0: "CABLE/INTERNET"
CASE 0 :
SELECT {@PHONE}
CASE 1 : "CABLE/PHONE"
CASE 0 : "CABLE ONLY"
CASE 0 :
SELECT {@INTERNET}
CASE 1 :
SELECT {@PHONE}
CASE 1 : "INTERNET/PHONE"
CASE 0 : "INTERNET ONLY"
CASE 0 :
SELECT {@PHONE}
CASE 1: "PHONE ONLY"
CASE 0: "NADA

 

[lbass]

Add parens as follows:

SELECT {@CABLE}
CASE 1 :
(
SELECT {@INTERNET}
CASE 1 :
SELECT {@PHONE}
CASE 1: "THREE PLAY"
CASE 0: "CABLE/INTERNET"
CASE 0 :
SELECT {@PHONE}
CASE 1 : "CABLE/PHONE"
CASE 0 : "CABLE ONLY"
)
CASE 0 :
(
SELECT {@INTERNET}
CASE 1 :
SELECT {@PHONE}
CASE 1 : "INTERNET/PHONE"
CASE 0 : "INTERNET ONLY"
CASE 0 :
SELECT {@PHONE}
CASE 1: "PHONE ONLY"
CASE 0: "NADA"
)

-LB