0 Replies Latest reply on Dec 29, 2016 8:16 AM by Josh Marks

    Calculated Field Challenge

    Josh Marks

      I'm not sure why this is a challenge for me. I appreciate any help.

       

      My data looks like this:

       

      I'm trying to create a calculate field that provides earned fees for each school (sample correct data is highlighted yellow). I wrote this expression and the syntax is correct but nothing is returned.:

      if attr([Act Header])= "04 Earned Fees" then sum([Amount]) end

      and this also fails to return anything

      if attr([Act Type])= "Revenue" then sum([Amount]) end

       

      But these do return data as expected:

      if attr([Number])= 1 then sum([Amount]) end

      if attr([School Type])= "ES" then sum([Amount]) end

       

      Thanks for any insights!

      Josh