Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
I'm sorry for the language. i m french
this is good: Count (DISTINCT {$<GERS={"=sum({1<MOIS={6}>}[Total Net])>0"} >} GERS)
but when i want to select a range the result is not good:
Count (DISTINCT {$<GERS={"=sum({1<MOIS={"<9>5"}>}[Total Net])>0"} >} GERS).
the formula with out "" is good but the results are 0
Count (DISTINCT {$<GERS={"=sum({1<MOIS={<9>5}>}[Total Net])>0"} >} GERS).
Have you got a solution?best regards