Set Analysis and AGGR

[cbaqir]

Any idea why this works just fine: =Sum({$<TASK_NAME={'PTO'}>} ACT_HRS)/sum( aggr(max(MONTH_CAP),FISCAL_MONTH_YEAR))

But this doesn't?=Sum({$<TASK_NAME-={'PTO'}>}ACT_HRS)/sum( aggr(max(MONTH_CAP),FISCAL_MONTH_YEAR))

The only difference is the inclusion/exclusion of the PTO task (= vs -=)

[rwunderlich]

I think the problem is the granularity of the dimensions, although I haven't been able to sort out a solution. The calculated Dim against TRX_Date produces two different aggregations of MONTH-CAP/ I don't see the problem if you use FISCAL_MONTH_YEAR as the Dim.

[cbaqir]

I am adding the expression within the Expressions tab in the chart. You are right that I also get a value in a text box. I think I was missing the FLAG dimension in the expression,