2 measures divided by 1 measure to create percentage

[keithericparsons777]

hi,

I think I have an order of operations problem.  I am using this formula to try to display a percentage and it's calculating differently that i would like it to.  

I am trying to add the Total Hours of "Quality Man" and "FUNDED EW"  then divide them by the Total Hours of "Compliance &" to get a percentage.  In it's simplest form, I think it's sum((a+b)/c).

Here's the formula:

sum(if(wildmatch("Task Project Title", '*Quality Man*'),[Total Hours])) + sum(if(wildmatch("Task Title", '*FUNDED EW*'),[Total Hours]))

/

sum(if(wildmatch("Employee Assigned Teams", '*Compliance &*'),[Total Hours]))

Can someone assist with the correct formula for doing this?

[stevejoyce · Accepted solution]

Just quickly looking at it, your first sum is not contained in parenthesis.  so yes it does look logically different.  See update below with green parenthesis added

( sum(if(wildmatch("Task Project Title", '*Quality Man*'),[Total Hours])) + sum(if(wildmatch("Task Title", '*FUNDED EW*'),[Total Hours])) )

/

sum(if(wildmatch("Employee Assigned Teams", '*Compliance &*'),[Total Hours]))

[keithericparsons777]

Much appreciated, simple enough!  thanks again.