Filtro Ano traz valor zero

[MatheusC]

Hello,

I am using this expression below, it will return the customer who did not buy in a certain period (Current year), it is showing me the value. But when I filter or period of the current Year it returns the value zero.

Count( {$< GroupTest = E({1<Annotate={"$(=Max(Annotate))"}>})>}distinct GroupTest)

But when I filter or current year period it returns zero value. It should return the value of customers that left the current one, even when it's unfiltered.

Any help on how to solve it will be appreciated, thanks in advance!

[MatheusC · Accepted solution]

Hello. Community

After a few attempts I managed to bring it in the way I needed, I'll leave my solution in case it can help someone else who also needs to reach a similar result.

Yours sincerely, @MatheusC 

count(distinct

     {<

    Annotate ={"$(=Max(Annotate)-1)"},

   GroupTest =e({<Annotate ={"$(=Max(Annotate))"}>} GroupTest)

     >}

GroupTest)