Search results

  1. M

    Help with expressions in default value

    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...
    • Maja
    • Thread
    • Replies: 1
    • Forum: Tables
  2. M

    Using 2 sum fields as the basis for a 3rd calculation returns no result

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

    Calculation shows same number on every line

    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...
Back
Top Bottom