2 Replies Latest reply on Nov 10, 2016 6:59 PM by Sherzodbek Ibragimov

    Multiple Actions After THEN in an IF-THEN Statement

    Justin Neal

      Hi all.  I can't post a packaged workbook due to sensative information.  I think my question is fairly simple, so we will start there and see if we can make any progress.  Here's what I need to do:

       

      IF ATTR([KAPI]) = 'LINE' THEN SUM([MILES])

      ELSEIF ATTR([KAPI]) = 'POLE' THEN SUM([POLECOUNT]) and SUM([ARMCOUNT])

      ELSE COUNTD([WORKORDERID])

      END

       

      Obviously, the part is red is not allowed and  I cannot seem to come up with a workaround.  Based on the code you can see that some of our KPIs are measured by count and some by sum and I'm trying to normalize them in order to plot them on the same graph.  Any one know of way to get the SUM([ARMCOUNT]) in the mix?