Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
Can someone help me with this expression please?