Search results

Hi there, I am trying to add a calculation of 2 fields (Total Value x POW) in another field of my master table. So I built the expression (=Sum[Total Value]*[POW]) in the Default Value property of the Weighted Value field. I've tried it with and without "sum" and the brackets. No luck with any...

Bob: Thank you so much!! Works just perfectly now :)

I'm using 2 sum fields in the footer (one is: =Sum([B&P Actual Cost]) and the other is: =Sum([Total Value]) to generate a third equation: =Sum([AccessTotalsB&P Actual Cost]/[AccessTotalsTotal Value]). The third equation is not showing anything on the report, but I don't have an error...

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.

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

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...