Calculating across a row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to collect a total across a row.
When I display the report it seems to only be calculating the first part of
the expression.
I'm I writing this wrong?
=Sum([NetProduction]+[Scrap])*([Usage
Factor])*(0.000067)*(6.32)/2000+Sum([NetProduction]+[Scrap])/1000*([KN-6030])*(0.001454)*(0.02)/2000+Sum([NetProduction]+[Scrap])/1000*([SON
ADH])*(0.000239)*(0.0036)/2000
Usage Factor, KN-6030, and Son ADH are fixed numbers that I have put in a
table.
 
What you are describing sounds quite like ... a spreadsheet! Is there a
reason you haven't exported the data from your table/query to Excel and done
the calculations there?

If you have an expression like the one you posted, any field containing a
null would "propagate" -- and I have no idea what you mean by "only
calculating the first part" -- what is the output of the expression?

If you have multiple fields (NetProduction, Scrap) that hold the same kind
of data (it MUST be the same kind, you are trying to add them together),
your data structure might benefit from further normalization. In your case,
with only two fields, it might be more work than it's worth. Are you quite
certain, though, that you'll never need more than two?
 
Back
Top