Apparently its been a while since I've had to create a multi if statement formula and I'm stuck... Can any one please tell me what I'm doing wrong!
IF ([CUSTOMER_SEGMENT_P] = "SLG") OR ([CUSTOMER_SEGMENT_P] = "K-12") OR ([CUSTOMER_SEGMENT_P] = "Graphic Communications") OR ([CUSTOMER_SEGMENT_P] = "Targeted") OR ([CUSTOMER_SEGMENT_P] = "Federal" )OR ([CUSTOMER_SEGMENT_P] = "SMB") && [FY RO MIF] = "YES CASH" THEN [FY Start ASP]*.15 ELSE "" ENDIF
Solved! Go to Solution.
One issue is you are combining a numeric function with a string function. The Else should be a 0.
THEN [FY Start ASP]*.15 ELSE ""
if ([CUSTOMER_SEGMENT_P] = "Strategic") then [RO TEST]*0.3209 + [RO TEST]
ELSEif ([CUSTOMER_SEGMENT_P] = "Enterprise") then [RO TEST]*0.224 + [RO TEST]
ELSEIF ([CUSTOMER_SEGMENT_P] = "Targeted") then [RO TEST]*0.1660 + [RO TEST]
ELSEIF ([CUSTOMER_SEGMENT_P] = "SLG") THEN [RO TEST]*0.1580 + [RO TEST]
ELSEIF ([CUSTOMER_SEGMENT_P] = "K-12") THEN [RO TEST]*0.1990 + [RO TEST]
ELSEIF ([CUSTOMER_SEGMENT_P] = "Federal")then [RO TEST]*0.1790 + [RO TEST]
ELSEIF ([CUSTOMER_SEGMENT_P] = "Graphic Communications") then [RO TEST]*0.1230 + [RO TEST] or if ([Account Coverage] = "Inside Sales")then [RO TEST]*0.530 + [RO TEST] else 0
endif
now i'm getting a parse error. Could it be something with the underlined portion of my formula? I tried adding another "endif" that didn't work. When I used elseif, the formula went to black & white. So i'm at another lose here. Is it the parentheses or do I need a comma?