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 ,

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

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

The correct answer was 1,04 so that solved my problem, thanks guys for all your help