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

Hi,

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
 =(Sum({}numerator)/Sum({}denominator))
[X]

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?

/John

• ###### Re: Discard fields table calculation?

Would you be able to share some numerical data and the output you are looking to get out of it?

• ###### Re: Discard fields table calculation?

Sure.

Employee, Team, Yesterday, Yesterday Department

Jane Doe, Team A, (5/2), (10/5)            (departmentflag = 1)

John Doe, Team B, (5/3), (10/5)            (departmentflag = 1)

James Bond, Team C, (9/6), -                    (departmentflag = 0)

Don't know if this got any clearer.

• ###### Re: Discard fields table calculation?

It hasn't, are you able to provide a app you are working with to help you better?

• ###### Re: Discard fields table calculation?

Sorry, I can not share app due to company policy.

Lets make the problem easier instead.
In the last column I want to show the sum of the team/groups achievement.

Name, Team, Result, Team Result

John  , T1     , 5         , 8

Jane  , T1     , 3         , 8

I want the SET-formula to calculate the Team total result on each row.

I don't know I can explain it any easier.

• ###### Re: Discard fields table calculation?

If this is needed directly in a chart, you can try this

Sum(TOTAL <Team> Result)

• ###### Re: Discard fields table calculation?

Thank you for your help and guiding me in the right direction!

Sum({<Yesterday={1}, Team=, Employee=>} TOTAL denominator)