This content has been marked as final. Show 2 replies
Sheet 3 in attachment, I need measures for AOV, AOV Score, Close Rate, and Close Rate Score to be blank or null for the Agent LOB "Care Agent". I've tried AOV using the calc below, it's under AOV (Copy), however, I'm getting an error saying "Expected Type String, Found Float. I'm not sure how to fix that.
IF ATTR([Agent LOB]) = "Care Agent" THEN ""
ELSEIF ATTR([Agent LOB]) = "Sales Agent" THEN SUM([Sheet2 (test book)].[1-90 Day Amount])/COUNT([Sheet2 (test book)].[St])