topic Re: Displaying department results for certain employees in App Development

Displaying department results for certain employees

aljaztoman — Sat, 16 Nov 2024 19:19:07 GMT

Hello,

I am trying to display department results only for certain employees. Please see below simplified case.

For employee Jarvis (or those, who do not have A and B values), i wish to display those sums, grouped by his DEPT.

How can I do this with set analysis?

Thank you in advance!

Kushal_Chawda — Mon, 13 Jan 2020 14:58:22 GMT

Would you need script solution or front end?

Kushal_Chawda — Mon, 13 Jan 2020 15:14:36 GMT

on frond end, create a straight table

Dimension:

Employee

Dept

Expression:

=if((sum(A)+Sum(B))=0,
sum(total <Dept> aggr(sum(A)+Sum(B),Dept)),sum(A)+Sum(B))