Columns names are "Suspense > 90 days" and "Suspense < 90 days". Valuation date column contains the month end date (See table below).
I need to be able to find out: Of the total suspense for May 2018, what part of this total is the Suspense < than 90 days.
I have a variable created vCurrentDate =Date#(Max(ValuationDate)). I have used this in other formulas to populate the most current information.
Sum({$<ValuationDate={'$(vCurrentDate)'}>}[Suspense >90 days])
Suspense > 90 days | Suspense < 90 days | Valuation Date |
---|
1000 | 250 | 1/31/2018 |
1250 | 300 | 2/28/2018 |
950 | 200 | 3/31/2018 |
575 | 658 | 4/30/2018 |
325 | 12500 | 5/31/2018 |
Can someone help me with this expression please?