running total problem

[Durango122]

Hi folks
cr 9.0
ms sql
i had a previous post but i did not get the right info to solve my problem
i have a report that has 2 group
gr1 is channel
gr2 id uni_user

here is what it looks like
these are my collumns
ChannelC
assigned to |lunch|dinner|fax|phone|email
gr1 jim 20 6 1 2 3
gr1 bob 0 1 3 1 0
gr1 alice 23 5 6 1 2
gr2 total 10
i created running total for the assigned to name as follow
Running total name: Lunch
field to summarize: CALSCHED.SCHTYPE
type os summary:disctinct count
evaluate: each record
resetn change of group#2 uni_user
i get this 20,0,23

now i need to add the result from gr# 1 uni_user
to gr#2 channel with is the total collumn as above
i tried a running total but not working

here is what i tried to do
Running total name: total0
field to summarize: CALSCHED.SCHTYPE
type os summary:disctinct count
evaluate: each record
resetn change of group#1 channel
but i dont get the total right

i get 10 not 43
what could it be
thanks





Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40

 

[Durango122]

update
on my gr 1 in the running total i have this
Running total name: Lunch
field to summarize: CALSCHED.SCHTYPE
type os summary:disctinct count
evaluate: formula CALSCHED.SCHTYPE = 'Lunch"
resetn change of group#2 uni_user


Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40

 

[Durango122]

go it
report option convert nulll to default
works


Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40