I'm trying to sum an amount field that is recorded as text.  So it needs to be converted into Currency, but I only want it to sum if a different field is equal to 1.  So here's what I've got and the formula editor won't take it.

 

 

${ml_pic10md.AMOUNT}

Sum ({ml_pic10md.AMOUNT},{ml_pic10md.FDISP} = "1")

 

 

What am I missing?  Something tells me I'll be visiting these forums a lot in the coming weeks...

 

"A number, currency amount, boolean, date, time, date-time, or string is expected here."

 

And it highlights the word "Total"

 

 

 

 

I'll be frank, I really know nothing.  I've got the complete reference to XI by George Peck, but no personal knowledge really in how to do this.  If it was MS access I could wouldn't have any issues writing the string, but since I can't directly import SQL lines from there I'm going to get stuck a lot

 

Maybe some more information will help.  It's an amount field, that contains text characters, not numeric characters.  So it has to be converted to Currency or numerical values before it can be summed. 

 

How can I convert it to a Currency AND include the summation in the same formula?

 

For example, in MS Access if you enter a table and select design veiw, the normal setting is that each field is a text field but you can still enter numbers.

 

That's the case with these and we don't want to change the field structure we just want the report to change it when the report is run.