Result Formula in Combined Report
Hello,
We have a combined report on Custom Object 1 and Activities and are trying to run a calculation from fields in CO1 and in a field in Activities. The calculation should be: (% Complete + % Fully Quoted + % Partially Quoted)/3. % Complete is coming from Activities and % Fully Quoted and % Partially Quoted is coming from CO1.
I have attempted adding a result column with (SUM(saw_3 BY saw_3) + SUM(saw_7 BY saw_7) + SUM(saw_8 BY saw_8))/3*100.
saw_3 = % Complete from Activities
saw_7 = % Fully Quoted from CO1
saw_8 = % Partially Quoted from CO1
When I use the formula the results are correct when there are values in the fields: Fully Quoted and/or Part Quoted. But, if there is a value in the % Complete the results are wrong.
We have a combined report on Custom Object 1 and Activities and are trying to run a calculation from fields in CO1 and in a field in Activities. The calculation should be: (% Complete + % Fully Quoted + % Partially Quoted)/3. % Complete is coming from Activities and % Fully Quoted and % Partially Quoted is coming from CO1.
I have attempted adding a result column with (SUM(saw_3 BY saw_3) + SUM(saw_7 BY saw_7) + SUM(saw_8 BY saw_8))/3*100.
saw_3 = % Complete from Activities
saw_7 = % Fully Quoted from CO1
saw_8 = % Partially Quoted from CO1
When I use the formula the results are correct when there are values in the fields: Fully Quoted and/or Part Quoted. But, if there is a value in the % Complete the results are wrong.
0