Forum Discussion

Quenjo's avatar
Quenjo
Icon for Helper II rankHelper II
3 years ago
Solved

Divide two fields from different table to calculate rentability

Hi community,   I have the following situation :     First column here represents a task, second column the effective time spent on the task and the third column represents the time that w...
Need Help
  • Thejeswar's avatar
    Thejeswar
    3 years ago

    Hi Quenjo ,

    Try using it this way

    Rentabilité(100%) = 

VAR resultat = IF (ISBLANK(SUM('change_task'[duration])), BLANK(), DIVIDE(SUM('otp'[Forfait du projet(H)]), SUM('change_task'[duration])) -1 )
RETURN
    SWITCH (
        TRUE (),
        ISINSCOPE ( change_task[number] ), BLANK (),
        ISINSCOPE ( otp[u_number] ), resultat,
        ISINSCOPE ( company[name] ), resultat,
        resultat
    )
Thejeswar's avatar
Thejeswar
Icon for Super User rankSuper User
3 years ago

Hi Quenjo ,

Try using it this way

Rentabilité(100%) = 

VAR resultat = IF (ISBLANK(SUM('change_task'[duration])), BLANK(), DIVIDE(SUM('otp'[Forfait du projet(H)]), SUM('change_task'[duration])) -1 )
RETURN
    SWITCH (
        TRUE (),
        ISINSCOPE ( change_task[number] ), BLANK (),
        ISINSCOPE ( otp[u_number] ), resultat,
        ISINSCOPE ( company[name] ), resultat,
        resultat
    )
Quenjo's avatar
Quenjo
Icon for Helper II rankHelper II
3 years ago

Hi Thejeswar 

 

This is exactly what I was searching ! Thank you a lot for the help provided 🙂