topic Re: Problem if aggregator in App Development

Problem if aggregator

Heurasein — Thu, 29 Sep 2022 17:07:34 GMT

Hi, I have a problem. I need to make a condition in a field.

I trying using this function, to give me a count of values in the HA-ODS% field with the condition of >=0.5%

=count(aggr(distinct(if((Sum({<TAG_FONTE={'SLD_HA','RES_HA'}>}VALOR)-Sum({<TAG_FONTE={'SDA','RES_DD'}>}VALOR))>=0.5,'NOK','OK'))))

The percentage of HA-ODS(%) is with this function (Sum({<TAG_FONTE={'SLD_HA','RES_HA'}>}VALOR)-Sum({<TAG_FONTE={'SDA','RES_DD'}>}VALOR)

Re: Problem if aggregator

UncleRiotous — Fri, 30 Sep 2022 07:39:12 GMT

I could be completely wrong but have you tried doing count(if(aggr(distinct((Sum instead of count(aggr(distinct(if((Sum ?

Re: Problem if aggregator

BrunPierre — Fri, 30 Sep 2022 07:53:18 GMT

The way I see it the expression counts output values 'NOK' and 'OK' and not values in HA-ODS%.

Nevertheless, Your Aggr() is without a stated dimension or dimensions.

Count(Aggr(IF(Sum({<TAG_FONTE={'SLD_HA','RES_HA'}>}VALOR)-Sum({<TAG_FONTE={'SDA','RES_DD'}>}VALOR)>= 0.5,'NOK','OK'),[Dimension(s)]))

Re: Problem if aggregator

Heurasein — Wed, 05 Oct 2022 17:09:29 GMT

I don't have a dimension, the dimension I need is the number of this set analysis give me Sum({<TAG_FONTE={'SLD_HA','RES_HA'}>}VALOR)-Sum({<TAG_FONTE={'SDA','RES_DD'}>}VALOR