topic Re: COUNT function: Error in set modifier in App Development

COUNT function: Error in set modifier

JVET — Fri, 29 Apr 2022 07:28:08 GMT

Hello.

I´m properly using this expresion on my app:

Aggr(sum(importe)-(15*max(clientes,mes_alta)),mes_alta)/sum(aggr(Max(clientes),mes_alta))

Now, I need counting how many of that values are less tan 0

I´ve tried this:

=count({<Aggr(sum(importe)-(15*max(clientes,mes_alta)),mes_alta)/sum(aggr(Max(clientes),mes_alta))={'<0'}>})

but returns "error in set modifier".

Can help me?

Thanks.

Re: COUNT function: Error in set modifier

vinieme12 — Fri, 29 Apr 2022 08:02:44 GMT

if(
Aggr(
(sum(importe)-(15*max(clientes)))
/
(Max(clientes))
,mes_alta) > 0
,
Aggr(
(sum(importe)-(15*max(clientes)))
/
(Max(clientes))
,mes_alta)
)

Re: COUNT function: Error in set modifier

Andrea_Spinetti — Fri, 29 Apr 2022 08:18:48 GMT

Hey @JVET, I agree with @vinieme12's approach in this case as Set Analysis may not be the best option for this kind of calculation.

Re: COUNT function: Error in set modifier

JVET — Fri, 29 Apr 2022 09:15:16 GMT

Hello @vinieme12 , thanks by your response. Your idea has not error, but doesn´t give me the result I need. When I calculate this:
Aggr(sum(importe)-(15*max(clientes,mes_alta)),mes_alta)/sum(aggr(Max(clientes),mes_alta))
I need to count in a different frame, how many of that values are negative.
Thanks.

Re: COUNT function: Error in set modifier

MayilVahanan — Fri, 29 Apr 2022 09:33:35 GMT

Try like below

Sum(Aggr(If(Aggr(sum(importe)-(15*max(clientes,mes_alta)),mes_alta)/sum(aggr(Max(clientes),mes_alta))< 0, 1), mes_alta))

Re: COUNT function: Error in set modifier

MayilVahanan — Fri, 29 Apr 2022 09:35:20 GMT

Can you please inform the reason for doing aggr() function in all places.
importe, clientes, mes_alta are coming from same table? or different table?

Re: COUNT function: Error in set modifier

JVET — Fri, 29 Apr 2022 09:42:43 GMT

This works fine. Than you so much!!!