7 Replies Latest reply: Jan 6, 2016 11:00 AM by Gabriel Oluwaseye RSS

    Sum of Current Year

    Daniel Mann

      Good Morning,

       

      Could someone help, I think I have something wrong.

       

      I have created the following:

       

      Sum({$<Year={$(=Max(Year))}>} SUM([Crew])

      -

      Sum({<[Accident Category]={'Total Recordable Cases (TRC)'}>}[Crew])

      -

      Sum({<[Accident Category]={'Lost Time Injuries (LTI)'}>}[Crew]))

       

      I want to get the total of Crew for the current year minus the totals of TRC and LTI.

       

      But it is not working, anyone see why?

       

      Thanks