1 Reply Latest reply on Mar 1, 2016 6:13 PM by Adam Crahen

    Counting Aggregate String (IF function)

    Christopher Lee

      I have an IF function that essentially looks at dates of project due dates and puts "Complete", "Pending", or "Late" depending. Note below. I'm trying to count this aggregate to show how many are in each state. Ideally, I'd like this to be over time. Example, 5 completed projects in Jan, 6 pending, 2 late. ETC

       

      ProjectStatus

      if MAX([status_completed])= "1" then "Complete"

      elseif ATTR([32333].[Due Date]) < [today] and MAX([status_completed])="0" then "Late"

      else "Pending"

      End

       

      Know of any way to count project status without mixing agg/non agg error? Furthermore, I do have Date/Time so I want to show this trending.

       

      Thanks.