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 but it returns an error that the expression refers tot multiple colums and they can't be converted to a scalare value ?
 
Basically what i want to do is filter in table 'Adressen' on all rows where the colum 'Civiel gesloten' has a value and devide them by the number of complaints per team in the table 'Klachten'.
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]))

1 Reply

  • 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]))