help with Rangeavg for 12 months

[Anonymous]

Need help please see attached QVW

[sunny_talwar]

Checking

[sunny_talwar · Accepted solution]

This?

RangeAvg(Above(Sum({<Version={'000'}, [Acct Desc]={'ONHAND INVENTORY'}>} ActualDollars)/1000, 0, 3))

[Anonymous]

now i see that Total is causing the issue. Thanks for your help

[sunny_talwar]

No problem at all

[Anonymous]

attached

[sunny_talwar]

One option:

sum(aggr(If(Date = MonthStart(DATE), sum({<Version={'$(=vVer_value)'},[Acct Desc]={'AR'},FiscalYear={'$(vCY)'}>} PlanDollars)),DATE, Date))