weird sum on report

[Pedro]

Hi everyone
I'm building a report based on several crosstab qry and it seem ok with
values. That report has group values.
I want, at some point, a line with totals as well as a line with the
difference between 2 lines, like expenses to sales. Quite simple, i guess.
Result : not only it doesn't subtract in some grouping/levels, as well it
doesn't sum the other 4 lines i need.
Is this weird or not? (lol)
Tks in advance for all your help.
Pedro

 

[Duane Hookom]

Pedro,
I don't see anything wrong from where I sit. Of course, I can't see your
crosstabs, data, grouping levels, expressions, report setup, ... ;-)

 

[Pedro]

Duane,
Tks for your answer, but.
The problem it's fixed. Why?
In every objects i've put the =NZ and renamed all.
Then i "told" it to sum or subtract those fields.
Just for you to know.
Weird no?
Tks anyway
Pedro