lucasx15
Contributor III
2022-12-27
02:26 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)
483 Views
2 Replies
lironbaram
Partner - Master III
2022-12-28
03:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
it seems you miss the field you want to use as the dimension in the AGGR function
lucasx15
Contributor III
2022-12-28
08:35 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
443 Views