topic Re: Count, aggr, KPI issue in App Development

Count, aggr, KPI issue

danimarc12 — Sun, 08 May 2022 17:03:04 GMT

Hello everyone!

I have an issue with a KPI in my project work.

In my straight table I have many idMarca. I want to calculate the New Sales in the cur year so I'm using the expressions you can see in the bottom of the table (Data in my date field of my Master Calendar and datadocumento is the date field of the sale).

So, regarding the table, I have 6 new sales.

In my KPI, of course it's not correct, I wrote the expression in the bottom of the table and I'm obtaining a wrong value.

Could anyone explain my error and suggest me the correct expression?

Thanks to who's answering!

Re: Count, aggr, KPI issue

vinieme12 — Sun, 08 May 2022 17:20:15 GMT

=Count(DISTINCT Aggr( IF ( min(.......)>=date(YEarstart(.....)) , IdMarca), IdMarca) )

Re: Count, aggr, KPI issue

danimarc12 — Sun, 08 May 2022 17:25:44 GMT

Hi @vinieme12 ,

thanks for ur answer but it still wrog:

Re: Count, aggr, KPI issue

vinieme12 — Sun, 08 May 2022 17:49:20 GMT

your expression is incorrect, please paste the expression here so i can modify it for you

Re: Count, aggr, KPI issue

danimarc12 — Sun, 08 May 2022 17:51:20 GMT

@vinieme12 this is the expression of the KPI:

Count(DISTINCT Aggr( IF (min({<Data=>}date(datadocumento)) >= date(YearStart(max(Data)))) idMarca, idMarca))

Re: Count, aggr, KPI issue

vinieme12 — Sun, 08 May 2022 17:55:44 GMT

Count( Distinct
Aggr(
IF ( date(min({<Data=>} datadocumento)) >= date(YearStart(max(Data))), idMarca)

, idMarca)
)