Forum Discussion

RvdHeijden's avatar
RvdHeijden
Post Prodigy
7 years ago
Solved

Simple formula i thought

Goodday,   I need some help with this formula    Klacht per woning = DIVIDE(FILTER(Adressen;[civiel gesloten]<>BLANK());COUNT(Klachten[ploeg]))   This formula should be farely straight forward...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    Right, it is because FILTER returns a table and you need a scalar for all the parameters of DIVIDE. Perhaps try:

     

    Klacht per woning = DIVIDE(COUNTROWS(FILTER(Adressen;[civiel gesloten]<>BLANK()));COUNT(Klachten[ploeg]))
Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

Right, it is because FILTER returns a table and you need a scalar for all the parameters of DIVIDE. Perhaps try:

 

Klacht per woning = DIVIDE(COUNTROWS(FILTER(Adressen;[civiel gesloten]<>BLANK()));COUNT(Klachten[ploeg]))