Complex Set Analysis Aggregation

cbaqir — Fri, 20 Sep 2024 06:48:09 GMT

2 part question...

Where do I add the AGGR for the numerator and the denominator?

numerator/denominator = %

My numerator works without any AGGR but I can't get it to work with AGGR(numerator,hosptial_name,
cost_center)

(Sum({
< cy = {'1'},
cpp = {">=1<=26"},
data_source = {'api_productivity_budget', 'py_api_productivity_budget', 'ppy_api_productivity_budget'}
>}
budgethours_uos) *
Sum({
< cy = {'1'},
cpp = {">=1<=26"},
data_source = {'api_productivity_budget', 'py_api_productivity_budget', 'ppy_api_productivity_budget'}
>}
volume))

The denominator is having problems also with getting it to work with AGGR(denominator,hosptial_name,
cost_center)and where to put the * 80:

( Sum({
< cy = {'1'},
cpp = {">=1<=26"},
data_source = {'api_productivity_budget', 'py_api_productivity_budget', 'ppy_api_productivity_budget'}
>}
prodfte)*80)

Re: Complex Set Analysis Aggregation

cbaqir — Fri, 20 Sep 2024 16:57:07 GMT

I figured it out:

sum(aggr(
{<cy = {1},
cpp = {">=1<=26"},
data_source = {'api_productivity_budget', 'py_api_productivity_budget', 'ppy_api_productivity_budget'},hosptial_name = {"*"}, // Include all hospitals
cost_center = {"*"}>}
(sum(budgethours_uos* volume))
,
pp_num,
FiscalYear2))

/
sum(aggr(
( Sum({
< cy = {'1'},
cpp = {">=1<=26"},
data_source = {'api_productivity_budget', 'py_api_productivity_budget', 'ppy_api_productivity_budget'}
>}
prodfte)*80)
,
pp_num,
FiscalYear2))

topic Re: Complex Set Analysis Aggregation in App Development

Complex Set Analysis Aggregation

Re: Complex Set Analysis Aggregation