Multiple If Statement HELP

Question

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

Alteryx.jpg

cjaneczko · Accepted Answer

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 ""