Hi,
I am designing the report like
Customer , year, GL indicator, D/C indicator, Amount

Here I required create the formula fields like
Trade
(if {GL Indicator}="T" and {D/C Indicator}="D" then Amount) - (if {GL Indicator}="J" and {D/C Indicator}="C" then Amount)

and
Security
(if {GL Indicator}="S" and {D/C Indicator}="D" then Amount) - (if {GL Indicator}="J" and {D/C Indicator}="C" then Amount)

But I am getting the wrong vales for Security.

Could you please suggest me how can I design the formula field for that.

With Regards,
Krishna Reddy.

Hi Lockwelle,

Thanks for your reply,

Here I required to create 2 formula fields like
1. Trade
(if {GL Indicator}="T" and {D/C Indicator}="D" then Amount) - (if {GL Indicator}="J" and {D/C Indicator}="C" then Amount)

2. Security
(if {GL Indicator}="S" and {D/C Indicator}="D" then Amount) - (if {GL Indicator}="J" and {D/C Indicator}="C" then Amount)

Could you please suggest me detail how can I define this objects .
I a new to this Crystal Reports.

With Regards,
Krishna