Conditional Data Display in Crystal Report

I have a Report.
Data I am getting from table CKAmt.
In this report there is two fields.
1 - Amount.
2 - Mode.

Now What i want is,
if Mode is PAID then Amount should be ZERO.
ELSE Amount is whatever.
LVL 1
crystal_TechAsked:
Who is Participating?
 
peter57rConnect With a Mentor Commented:
Create a formula field as follows and add it to your report...

If {ckamt.Mode}="paid" then
0
else
{ckamt.amount}
0
 
crystal_TechAuthor Commented:
Thanks Peter
Its working like charm. :-)
0
 
crystal_TechAuthor Commented:
Thanks for Quick Reply.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.