Thanks - all,

Whilst I understand the logic of Doug's formulas, I don't know where in Crustal to put it, however I have embedded the fields in a text box.

Doug - where do you actually put such a formula? I can see al the 'X2' buttons in the field options, however which ones can hold this formula? I assume not the first one, as that formula options seems to control suppression?

cheers

Rob

RobertWild wrote:


In Crystal if you open up Insert > Field Object... you will get the Field Explorer window. Right below Database Fields is Formula Fields. You would need to create a new formula and then you could insert Doug's formula there. Once the formula is created it behaves pretty much like a database field except that there may be some limits on summarizing formula fields.

Drew

RobertWild wrote:


Doug wrote:


So I cheated and just built it CR 9. If you can't open it, sorry

Doug

Unfortunately not - I'm only on the "free" copy of 8.5, and yes, I am finding odd problems with it.

cheers & many thanks

Rob

Still on the same user issue, can anyone advise on how to force CR to perform a sum operation on a text field?

One of the fields in the label is a small numeric value containing the number of copies of a newsletter that will appear on the label. The field that we are using to control this number is the Address Attributes Comments Field, nominally a text field.

When I attempt to force CR to undertake a sum function on the field, it comes back with an error indicating that it cannot 'sum' a non numeric or currency field.

How can I force CR to see this field as a numeric field so it can sum it's values?

many thanks in advance,

Rob

RobertWild wrote:


You'll have to create a formula to convert the text field to a numeric. The formula is CDbl().

Drew