Forum Discussion

AllanBerces's avatar
AllanBerces
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

Average of Two and Three Column

Hi Good day, Pls need assistance on how can i have the Overall output on my table base from average. a. If the Fab column is 0 it will average by 3 three column (JC, Fab and Mat). b. if the Fab co...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    AllanBerces  This works.

     

     

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
2 years ago

Hi AllanBerces 
You can use the formula :

Overall = IF(ISBLANK([FAB]) ||ISBLANK([JC]) || ISBLANK([MAT]),DIVIDE([MAT]+[JC]+[FAB],2),DIVIDE([MAT]+[JC]+[FAB],3))

pbix is attached

 If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
AllanBerces's avatar
AllanBerces
Icon for Post Prodigy rankPost Prodigy
2 years ago

Hi Ritaf1983  Thank you for you reply

i just notice theres something wrong on the column, the value of 2 instead of 72 and 94.

 

Thank you

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    2 years ago

    There was a "writer error " .
    ' instead of +

    The correct formula is :

    Overall = IF(ISBLANK([FAB]) ||ISBLANK([JC]) || ISBLANK([MAT]),DIVIDE([MAT]+[JC]+[FAB],2),DIVIDE([MAT]+[JC]+[FAB],3))

     If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.