2 Replies Latest reply on Dec 20, 2016 8:50 AM by Norbert Maijoor

    Calculated Field Issues

    Brian Zito

      I'm trying to create 1 calculated field that includes the SUM of two dimensions. In this case, I need to SUM Unique Events when the Event Label= 75% or 100%. Can someone please let me know what the correct syntax should be?

       

      Attempt 1:

      SUM(IF [Event Category]="Scrolling" AND [Event Label]="100%" THEN [Unique Events] END )

      OR

      SUM(IF [Event Category]="Scrolling" AND [Event Label]="75%" THEN [Unique Events] END )

       

      Attempt 2:

      SUM(IF [Event Category]="Scrolling" AND [Event Label]="100%" OR [Event Label]="75%"  THEN [Unique Events] END )

       

      Message was edited by: Brian Zito