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