Calculation shows same number on every line

[Maja]

Good morning,

I created two fields with calculations using the Expression Builder. However, both fields are returning the same number (in one case a percentage) for every line of the report. Formula #1 is: =Sum([Q -B and P Percentage]![B&P Actual Cost]/[Q - B and P Percentage]![Total Value]) - which is giving a 4.7% result on every line. Formula #2 is: =Sum([Q -B and P Percentage]![B&P Actual Cost]/[Q - B and P Percentage]![B&P Est Cost]) - which is giving the same dollar figure on every line.

Can anyone tell me what I've done wrong and how to fix it?

Many thanks,

maja

 

[DCrake]

Depends whre you have the calculation. Is it in your detail section? You may ned to create the calculation in your underlying query and then refer to it in your report.

 

[Maja]

Yes, the formulas are in the detail section of the report. Will they work if I move them to the query?

 

[DCrake]

Only one way to find out... Try it...

 

[Maja]

Ok, I put all the calculations into the query and it worked....with 1 exception. I need to do the following calculation on 2 of the sums I put in the query to get the percentage field: B&P Actual / Total Value. However, when I create the expression in the report, nothing is showing up.