Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
I'm having trouble to Sum by distinct. Below is what my data would look like.
Phase | Begin | End | Working Days |
Induction | 3/19/2020 | 4/2/2020 | 14 |
Disassembly | 4/3/2020 | 4/25/2020 | 22 |
Inspection | 4/26/2020 | 5/2/2020 | 6 |
Repair | 5/3/2020 | 6/20/2020 | 48 |
Assembly | 6/21/2020 | 7/12/2020 | 21 |
Test | 7/13/2020 | 8/14/2020 | 32 |
Sold | 8/15/2020 | 8/20/2020 | 5 |
I'm trying to Sum the Working Days by distinct names. For example, I want the sum of Induction, Disassembly, and Inspection. I'm using the below expression and I'm not having any success. Please help Thank you.
Sum(Aggr(Sum(distinct{<Phase = {'Induction','Disassembly','Inspection',}>} Working Days), Phase))
I think your issue is that your Working Day should be delimited with square brackets:
Sum(Aggr(Sum(distinct{<Phase = {'Induction','Disassembly','Inspection',}>} [Working Days)], Phase))
I think your issue is that your Working Day should be delimited with square brackets:
Sum(Aggr(Sum(distinct{<Phase = {'Induction','Disassembly','Inspection',}>} [Working Days)], Phase))
Lisa,
I added the square bracket and got rid of an extra coma after Inspection and it work like charm. Thank you so much.