Writing a Report with Goldmine 6.0

[sandingdude]

I am attempting to add a field to one of the reports.

I was able to bring over the fields I need the only they are no calcuating the value I need.

I want it to do this calculation:

(2/5) *100 = 40

And on the report just put 40.

But inside its showing me the equation (2/5) * 100

Here is my expression:

(&syfield20"/"+&syfield12+)"*"+&100+

Did I forget the equals somewhere?

Thanks in advance.

 

[Adecaro]

have you tried using dbase expressions?

ex. ((contact2->udef20)/(contact2->udef12))*100

 

[sandingdude]

Adecaro

Thank you for your response.

I havent tried using dbase expressions. Is there a good web resource I can use to learn dBASE syntax?

Will your sample expression work? Or do I need to replace your field names with my field names?

Thanks,

Dave

 

[Adecaro]

http://support.frontrange.com/support/goldmine/pdf/6.5/usingdbaseexpressions.pdf

That is a manual direct from FrontRange on Dbase expressions. I am not entirely sure if the above code will work or not, as your initial code was apparently over my head(not big in SQL). Feel free to try it, you will need to replace the field names though. Dbase is also refered to as Xbase, for future reference and web searches.

just a quick tip, your field will be located in one of two places in goldmine, either contact1 tabel or contact2 table. This is the Dbase format for denoting a field in goldmine (contact1(or2)->fieldname)