Hello Francois,

In those type of cases we like to store each of the calculations with its filter (which then needs to be in a case when statement) in a separate variable and later use those variables to get to the desired outcome within a new component.

Could you try this and let me know whether it worked?

Best

Denis

Hello Denis, thank your for your time !

Your advice is consistent, the formula is also way more readable and reemployable with variables

I finally succeed, I have not anymore the problem I had this morning with the Filter inside an AVG

I am a newbie on Celopeers, do you advise me to keep this post or to delete it ? I hesitate because I doubt my post is worth it but your answer may help some others

Best regards,

François

Hi @francois.court,

Glad it worked and no worries at all - thanks exactly what this forum is made for!

Please also keep this post and do not delete it. I am sure that there are others who will also benefit from it 😊

Have a good day,

Denis