Creating a formula using the answeres of two other formulas.

[mbs9]

I have a field called {REQUESTS.RECIEVE_DATE}. From it I can get total number of requests recieved LastFullMonth and MonthToDate. What I want to do is divide the two and multiply by 100 so that I get a percentage of requests recieved so far this month compared to the total last month. I have tried various formulas such as-

Count ({REQUESTS.RECIEVE_DATE} in MonthToDate)/ Count ({REQUESTS.RECIEVE_DATE} in LastFullMonth)

but I keep getting errors. Please help. Thanks.

 

[kenhamady]

You have to use conditional totals. See the FAQ on how to do conditional (Part of FAQ 1.B) and then you can use the totals in your formula.

Don't let the word "condition field" in the summary function list fool you. This field means a group field. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)