Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
it seems you miss the field you want to use as the dimension in the AGGR function
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.