Logic question

[EFREE]

I have a report that totals the number of interactions for each way of communication to our company (email, fax, phone, etc) and then totals it at the bottom.

Now i am trying to make another column next to it to show what percent of all interactions each way represents.

The formula should look like this for phone calls:
totalPhoneCalls / totalinteractions * 100

how do i put this into the respective column

any ideas are welcome!

thanks

 

[BoniR]

Report in what?
Crystal, R&R, ??
B~

Boni J. Rychener
Hammerman Associates, Inc.
Crystal Training and Crystal Material
On-site and public classes
Low-cost telephone/email support
FREE independent Crystal newsletter

http://www.hammerman.com

800-783-2269

 

[xlbo]

BoniR - this is an MS SQL Server REPORTING SERVICES forum so I would guess that is the reporting format being asked about

EFREE - look at creating user defined variables in the report itself or you could calculate this at runtime as part of the SQL

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question

 

[BoniR]

Thanks for clearing that up!
B

Boni J. Rychener
Hammerman Associates, Inc.
Crystal Training and Crystal Material
On-site and public classes
Low-cost telephone/email support
FREE independent Crystal newsletter

http://www.hammerman.com

800-783-2269

 

[Catadmin]

EFREE,

Take a look at thread1462-1074435 where I discuss setting up a counter variable within RS itself. You can change the code where it says "+= 1" and see if it will allow you to put fields in (like you do in expression builder) to total your variables.

I haven't tested this, but if it worked for what I did, I don't see why it wouldn't work for you.

Also, Hitchhiker's Guide to SQL Server Reporting Services says there is a RunningValue() function in RS. (Page 434). I think it's only for a count, but I thought I'd mention it in case you had other uses for it.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[ookete]

I can't quite visualize your table. Can you give me a quick example? Are interaction types along the top (columns)? What do rows represent... different dates?