Getselectedcount and Set analysis

juan_patrick — Wed, 25 Nov 2020 16:16:04 GMT

Hi!

I have the expression:

IF(GetSelectedCount(date)=0,

Sum({<consecutive= { $(=MAX(consecutive)-1)} >} field1),

(Sum(field1))

)

I have dates, and the rule is:

if there is no one selected, sum field1 by the max date

if there one or more than one date selected, sum field1 by that dates.

The code ots ok with the rule, but, its slos, and i think if I can do it all in set analysis will be faster than now.

Thanks!!

Re: Getselectedcount and Set analysis

prat1507 — Fri, 01 Jun 2018 16:01:44 GMT

Sum({<consecutive= { '$(=IF(GetSelectedCount(date)=0,MAX(consecutive)-1,'*')'} >} field1)