Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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))
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))