Skip to main content
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
lucasx15
Contributor III

Agrr with count and sum

Hello everybody. I have a doubt, how could Aggr use a sum within two count fields? My expression is like this:. What would be wrong?

 

 

			=COUNT(AGGR({<CD_HISTORY={57,89,10}>}
COUNT(
		{<CD_PROT={3535},FL_TYPE={'1 - ALT'}>} 
	%NR_PRESCR_PRODUCT)
+
COUNT({<FL_TYPE={'1 - ALT'}>}
	NR_SEQUENCE.SCALE)) DISTINCT NR_CLIENT)

 

Labels (1)
2 Replies
lironbaram
Partner - Master III

it seems you miss the field you want to use as the dimension in the AGGR function 

lucasx15
Contributor III
Author

Thank you for reply!

 

my values ​​are still coming in null. the idea is that everything I'm counting within that sum of counts is aggregated by nr_client, I don't know if the aggr I'm doing is incorrect.