Difficulty with AGGR()

[proctors]

Hi.

I have an expression that only works when I select an individual person, but when I take the filter off and show all of the individuals, the column goes to null.

Expression is

sum([RVU WORK])/((vThresholdGoal/12)*vToDateMonths)

Dimensions are

Department, Billing Provider, Service Provider, and Place of Service.

I'm guessing I need aggr(), but I'm not sure how to get it to work. Please see attachment, last column of the chart. Data scrambled, SA should be off.

[proctors]

Right now we have a Cycle group that includes cost center. Is there a way to make it dynamic such that the part that is underlined looks at the current cycle field? (e.g., Department, Cost Center, Program)

If(vFTE_Est = null() OR vFTE_Est < 0, [YTD Avg], vFTE_Est)*if(EST_Threshold <> Null() OR EST_Threshold < 0, EST_Threshold, Sum(TOTAL <[Cost Center], [Billing Provider]>Threshold))

[sunny_talwar]

May be this

If(vFTE_Est = null() OR vFTE_Est < 0, [YTD Avg], vFTE_Est)*if(EST_Threshold <> Null() OR EST_Threshold < 0, EST_Threshold, Sum(TOTAL <$(='[' & GetCurrentField([Group Name]) & ']'), [Billing Provider]>Threshold))