If your cell is within a Master/Details section (which are defined by ) then the measure should display automatically the value aggregated to the for that aprticular Master/Destail section (same holds true for break).
This leads me to two questions:
- What is the exact formula of your cell (maybe you are using any input/output contexts)?
B) Are you using a Master/Detail report? And if so where exactly is the “problem” cell positioned?
Regarding WHERE syntax (and pitfalls) for Business Objects Reporter variables or formulas, please take a look at the Reporter FAQ here.
Andreas 
(BOB member since 2002-06-20)