Conditional summing of values

  • Thread starter Thread starter Huck_M
  • Start date Start date
H

Huck_M

I have created a report from a query that includes an equipment "start up
date" and an "estimated days" required for equipment startup. The query and
report includes all equipment that has shipped but has not been started. I
can accurately sum the "estimated days" for the entire report, but I also
need to calculate the "estimated days" on only the equipment has a "start up
date" 90 days from the current date. Can anyone provide any guidance?
 
You can create conditional sums with expressions like:
=Sum(Abs({true/fals expression}) * {Expression To Sum})
For instance if you want to sum the sales for Mondays, you would use:
=Sum(Abs(Weekday([SaleDate])=2) * [UnitPrice]*[Quantity])
 
Back
Top