Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
ScenarioDateID | Portfolio | Total |
20160701 | A AUD OPT AU | - 337,065 |
20160701 | A CAD OPT AU | - 229 |
20160701 | A CPI OPT AU | - 17,770 |
20160701 | A CPI OPT2 AU | 13,322 |
20160701 Total | - 341,742 | |
20160704 | A AUD OPT AU | 1,238,323 |
20160704 | A CAD OPT AU | 33 |
20160704 | A CPI OPT AU | 378,288 |
20160704 | A CPI OPT2 AU | - 98,216 |
20160704 Total | 1,518,428 | |
20160705 | A AUD OPT AU | - 130,404 |
20160705 | A CAD OPT AU | 1,625 |
20160705 | A CPI OPT AU | 56,491 |
20160705 | A CPI OPT2 AU | - 150,693 |
20160705 Total | - 222,981 | |
20160706 | A AUD OPT AU | - 529,386 |
20160706 | A CAD OPT AU | 1,113 |
20160706 | A CPI OPT AU | - 4,093 |
20160706 | A CPI OPT2 AU | 14,396 |
20160706 Total | - 517,970 |
I have 4 dates, and each date has 4 portfolios, I need to total them by each date and out of that 4 dates total, I need to get 2nd lowest which is 341,712.
Kindly Help.
May be this
Min(Aggr(Sum(Value), ScenarioDateID), 2)