Forum Discussion

RonaldvdH's avatar
RonaldvdH
Icon for Post Patron rankPost Patron
6 years ago
Solved

Need help with my formula

Guys, i need some help with my formula because i think im almost there but it still returns an error Basically i want a measure that calculates that IF [Aantal dgn] <> BLANK then it devides 2 values...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi RonaldvdH ,

    You can try to use below formula if it suitable for your requirement:

    Gemiddelde productiviteit LvC =
VAR div1 =
    CALCULATE ( SUM ( Table[Prognose duur] ); Table[Aantal dgn] <> BLANK () )
VAR div2 =
    CALCULATE ( SUM ( Table[Aantal dgn] ); Table[Aantal dgn] <> BLANK () )
RETURN
    IF ( div1 > 0 && div2 > 0; DIVIDE ( div1; div2 ) )

    If above not help, can you please share some sample data for test?

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi RonaldvdH 

 

If what you want to do is to avoid the error of dividing by 0, just use this formula:

 

Gemiddelde productiviteit LvC = Divide( SUM('V&P Civiel LvC'[Prognose duur]), SUM('V&P Civiel LvC'[Aantal dgn]), 0 )
 
anyway, if you want ot filter the blanks:
 
Gemiddelde productiviteit LvC =
IF( NOT( ISBLANK( SUM('V&P Civiel LvC'[Aantal dgn]) ) ), 
    DIVIDE( SUM('V&P Civiel LvC'[Prognose duur]), SUM('V&P Civiel LvC'[Aantal dgn])
          )
 )