Count, aggr, KPI issue

[danimarc12]

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!

DM

[vinieme12]

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

[danimarc12]

Hi @vinieme12 ,

thanks for ur answer but it still wrog:

[vinieme12]

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

[danimarc12]

@vinieme12  this is the expression of the KPI:

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

[vinieme12 · Accepted solution]

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

, idMarca)
)