Summing two fields in the details section (RESOLVED)
Hello everybody
I have a Crystal Reports report. In the details there are two numeric fields. Now, I would like Crystal Reports to create a calculated field, once again in the details section, that would be the sum of these two numeric fields. Can this be done?
Re: Summing two fields in the details section
yes. just create a new formula and make it fielda + fieldb
Re: Summing two fields in the details section
I see. But how do I create a new formula under the RDC?
EDIT : What I meant is that I can a new formula field named TotalSum, but I don`t know how to express field1 + field2 in the formula editor.
Re: Summing two fields in the details section
This is getting into a monologue. I finally used the code shown below in th formula editor.
Code:
If Not (IsNull({@UnboundCurrency2})) Then
{mhxanhma.Kostos_Agoras} + {@UnboundCurrency2}
Else
{mhxanhma.Kostos_Agoras}
The If statement checks for nulls. Otherwise if I just use
Code:
{mhxanhma.Kostos_Agoras} + {@UnboundCurrency2}
I get no value when UnboundCurrency2 is null.
thx, for the help