6 Replies Latest reply: Mar 7, 2017 10:52 AM by John Mårtensson RSS

    Discard fields table calculation?

    John Mårtensson


      I'm a newbie in this world so please be patient.


      This is the table object I have:


      EmployeeTeamYesterdayYesterday Department
      Jane DoeTeam A=(Sum({<Yesterday={1}>}numerator)/Sum({<Yesterday={1}>}denominator))[X]
      John DoeTeam B


      I also have a flag for the department.


      What I want is to make the same calculation but on the Department flag. I've looked in to the Aggr-function but didn't make it. Someone that has any suggestions?