2 Replies Latest reply on Aug 30, 2018 6:34 AM by Barb Reiser

    Calc Help

    Barb Reiser

      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])

      END