Using RangeSum when there are nulls AND when none of the above rows are nulls within your range
Hello,
For a pivot table I was asked to return the last three months average Quality Score when the month didn't have a quality score given. I did this by using the an if statement with the rangesum(above()):
However there will be instances where there may also be nulls or no data in the preceding three months as well. I need my expression to take the last three months that have data or are not null. How do I adjust my above expression to account for those scenarios? Below is an example. QA^^ is the field where I used RangeSum(Above)) for the Month of Jan-2021 it is giving the expected Quality Score a sum of points scored over points possible over the last three months, however, for month Feb -2021 its also taking the last three months but taking the Jan - 2021 month which is not what I want. In the case for Feb -2021 where one of the preceding months also returns no data I want it to pull the preceding months where there is data. **Also I don't want to apply this to the current month which I covered that in my if statement with IsCurrentMTD = '1' so that one is fine. Any suggestions would be nice. Thank you.
