Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, why only 1 row has to be one. You can add 2 expressions:
- One with: sum(aggr((sum(................),ORA,MACROSETUSO_DESCRIZIONE_PROGRAM,UTENTE)))
- Another with: sum(aggr((sum(................),ORA,MACROSETUSO_DESCRIZIONE_PROGRAM,UTENTE)))
-above(
rangesum(sum(aggr((sum(...............),ORA,MACROSETUSO_DESCRIZIONE_PROGRAM,UTENTE))))
Those with the 2nd expression higher than 10000 will have '1'. The expressiona re just to see the values returned and you can understand why it sets more than one '1'.