Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Working on problem to calculate the sum of values for the maximum created on date for each unique ID
ID | Projected Month pertains to | Created on | Projected Value |
4 | 2015-11-01 00:00:00.000 | 2015-11-09 09:47:01.363 | 160 |
6 | 2015-11-01 00:00:00.000 | 2015-11-07 20:14:03.250 | 500 |
6 | 2015-11-01 00:00:00.000 | 2015-11-15 11:17:18.370 | 700 |
7 | 2015-11-01 00:00:00.000 | 2015-11-07 20:13:31.223 | 4000 |
7 | 2015-11-01 00:00:00.000 | 2015-11-16 10:29:41.813 | 3000 |
8 | 2015-11-01 00:00:00.000 | 2015-11-16 10:30:26.400 | 700 |
Result looking for is sum of the highlighted ones above, total projection would equal 4560.
Not sure if need to find this in a load or if I can get it from expression.
Appreciate any assistance.
Try something like this: sum(aggr(FirstSortedValue([Projected Value], -[Created on]), ID))
- Marcus
Try something like this: sum(aggr(FirstSortedValue([Projected Value], -[Created on]), ID))
- Marcus
May be use an expression like this:
=FirstSortedValue([Project Value], -Floor([Created on]))
Dimension = ID and Projected Month
Awesome, so many functions that need to learn!
Loving the program and the community and look forward to being able to assist others myself in the future!