I am building an appeal analysis report so that we can get all of the information contained on an appeal performance analysis report and an appeal summary on one page.

Right now I am trying to calculate the response rate by dividing the count of gifts (a summary formula field) by the number of solicitations (a RE database field).  But it won't let me divide a field by another field and says a number is necessary.  Does it really only work if the "y" of (x / y) is an integer? 

Has anyone been able to solve a similar problem?  Or does anyone know a way to convert a RE database field into a format that will allow me to use it in an arithmetic operation?

 Thanks!

Make sure that the number of solicitations is numeric.  BB will often export numeric fields as formatted text.  You can find out by opening up the field explorer and using the last button on the toolbar there to toggle the data type.

If it's not numeric, you will need to convert it to numeric.

Drew

 You're right, it was actually a string!  I used ToNumber and it worked out fine.  Thanks!