Joined: 18 May 2012
Location: India
Online Status: Offline
Posts: 11
Topic: wrong values from crystal formula fields Posted: 24 May 2012 at 11:23pm
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.
Joined: 18 May 2012
Location: India
Online Status: Offline
Posts: 11
Posted: 27 May 2012 at 8:12pm
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.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum