sum function

[mdelgado100]

I am using crystal 85 and an access data base I crated

In my report, by month, I am attempting to get a sum of a column. sum(minutes_table).

I need a sum/count of minutes for a certain type.

Each of the formulas below give me the total for the month. It will not distinguish between types, what am I doing wrong?!

if {certain_type} = 890
then sum({minutes_table})
else 0

Also,

if {certain_type} = 890
then sum

Also,

if {certain_type} = 890
then sum({minutes_table}(minutes_date}, "monthly")
else 0

 

[mdelgado100]

This is the orginal sender, Maria

I changed the graph for my report and seems to show all the pieces, that'll work.

Thanks....Maria

 

[BB45]

Create a group by type and place your sum in the group footer

 

[ANDYPS]

HI I am unable to run the report.It gives"password error".Db is oracle.I tried to do the odbc but no luck.PL let me know how to do it?

 

[ANDYPS]

how to post a new thread?

 

[kskid]

ANDYPS,

As a new subscriber, please review faq149-3762 or faq149-237 very carefully. Also, this should have been a new thread so it would be easier to follow up on one item at a time.

Without more technical information, it would difficult to answer your question quickly.

As far as password error, check with your DBA.

Cheers,
-LW