Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
i am stuck while cal. the time spent in a project with the last modified date value.
Ex
project id | time | date | want result Ouput |
---|---|---|---|
90 | 6:00 | 16/01/2016 | 6:00 |
90 | 5:55 | 15/01/2016 | |
92 | 3:00 | 23/01/2016 | |
92 | 2:40 | 13/01/2016 | |
92 | 1:20 | 30/01/2016 | 1:20 |
total will be 7:10.
in text box and pivot chart i want to show.
i tried
max(aggr(sum(time),project id,date)) but it doesn't gave correct value
Result 6:00+ 300=9:00
it add the max value rather considering on date
Thanks in Advance
swati
it is unanswerred by mistaken chosen assumed answer.
kinldy help
Try this:
Sum(Aggr(FirstSortedValue(time, -date), [project id]))
Hi,
another solution without Aggr() might be:
hope this helps
regards
Marco