Using Formula fields to create a new field

[ruma20045]

I am tring to create field C = @a + @b where @a and @b are 2 formula fields. How can I achieve this? any help would be appreciated.

 

[Turkbear]

Hi,
Did you try :?
@C

@a + @b

What happened?






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

Create the formula and use:

{@a} + {@b}

If you get an error, try posting technical information, note that your post is devoid of anything about the software used, dataqbase, what's in the formulas, etc.

If @A or @B use summary functions, then you'll want to use a different method to summarize them, such as the exact same syntax within, or variables within a summing formula, and then displaying them later.

-k

 

[ruma20045]

Should I add it as a new formula or some place else

 

[Turkbear]

Hi,
It is a new formula so put it where you now have {@a} and {@b} ( replacing them or not, as you want0



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[ruma20045]

I tried this nad it does not work.

 

[Turkbear]

Hi,Does not work in what way?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[dgillz]

can you not create a new formula field?

In crystal 8.5 and older, insert, field object, formula field, rt click, new.

In crystal 9 and newer, go to fiel explorer, formula fields, rt click, new.


Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[Madawc]

Crystal lets you use formulas within formulas, and if there is a limit, I've not found it.

If you're not allowed to add, maybe the fields are not numeric. If {@a} & {@b} displays the two values, that's the problem. Try ToNumber({@a}) + ToNumber({@b})


Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10