topic Re: Discard fields table calculation? in App Development

Discard fields table calculation?

holynumbers — Fri, 24 Feb 2017 13:28:32 GMT

Hi,

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

This is the table object I have:

Employee

Team

Yesterday

Yesterday Department

Jane Doe

Team A

=(Sum({<Yesterday={1}>}numerator)/Sum({<Yesterday={1}>}denominator))

John Doe

Team B

=(Sum({<Yesterday={1}>}numerator)/Sum({<Yesterday={1}>}denominator))

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?

sunny_talwar — Fri, 24 Feb 2017 14:14:50 GMT

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?

holynumbers — Fri, 24 Feb 2017 14:37:54 GMT

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?

sunny_talwar — Sun, 26 Feb 2017 16:55:45 GMT

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

Re: Discard fields table calculation?

holynumbers — Mon, 27 Feb 2017 08:58:36 GMT

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?

sunny_talwar — Mon, 27 Feb 2017 10:32:55 GMT

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

Sum(TOTAL <Team> Result)

Re: Discard fields table calculation?

holynumbers — Tue, 07 Mar 2017 15:52:06 GMT

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

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