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?