4 Replies Latest reply on May 16, 2018 3:08 PM by Zhouyi Zhang

    Can you think of a workaround for this aggregate error?

    MATTHEW TEBBETTS

      Hi, the below screenshot should explain my issue. It shows the dates and volume per day, along with a calculated field called "Is Lower" which simply compares the "current volume" (from a related source) to the volume from each day and returns a 1 if it's lower.

       

      I want to add up the "Is Lower" column (and eventually divide by total records, so 3/10 resulting in 0.03 or 30%) but I keep getting the "cannot be further aggregated" error. Do you have any ideas on how I could get around this?

       

      eat2.JPG

      er3.png

       

       

      Thanks!