5 Replies Latest reply on Nov 26, 2018 6:22 AM by Ciara Brennan

    Unable to handle Aggregate and non aggregate argument

    Jaydeep basu

      The if statement works fine but when trying to add [Supported/UnSupported] = "Supported OS" it gives aggregate/non aggregate issue. trying to create a new measure and 2 different  color scheme for Supported OS and UnSupported OS

       

      [Supported/UnSupported] = "Supported OS"

      (IF (SUM([_Wsus Compliant count])/SUM([IP address Count]))>=99/100 THEN ">=99%"

      ELSEIF (SUM([_Wsus Compliant count])/SUM([IP address Count]))<99/100 AND (SUM([_Wsus Compliant count])/SUM([IP address Count]))>95/100  THEN "between 99% and 95%"

      ELSEIF (SUM([_Wsus Compliant count])/SUM([IP address Count]))<95/100 THEN "Under 95%"

      ELSEIF (SUM([_Wsus Compliant count])/SUM([IP address Count]))>=0 AND (SUM([_Wsus NonCompliant count])/SUM([IP address Count]))>=0 THEN "Red"))

      END

      OR

      [Supported/UnSupported] = "UnSupported OS"

      (IF (SUM([_Wsus Compliant count])/SUM([IP address Count]))>=95/100 THEN ">=95%"

      ELSEIF (SUM([_Wsus Compliant count])/SUM([IP address Count]))<95/100 THEN "Under 95%"

      ELSEIF (SUM([_Wsus Compliant count])/SUM([IP address Count]))>=0 AND (SUM([_Wsus NonCompliant count])/SUM([IP address Count]))>=0 THEN "Red")

      END