Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Add Formula to Field Post Reply Post New Topic
Author Message
MikeColeman407
Newbie
Newbie


Joined: 15 Apr 2015
Online Status: Offline
Posts: 3
Quote MikeColeman407 Replybullet Topic: Add Formula to Field
    Posted: 21 Apr 2015 at 7:15am
Hello, I am brand new to Crystal and SQL. I have a simple report with two tables using Crystal 2008 v12.1.0. I am using 6 fields from these tables with join. The report is going to tell me who has a net zero check. I have a field called TRANSAMT that is going to be the pre-check amount. I would like the report to only pull in checks that have an amount of 0 or less. Please advise. Thank you for your expertise.

Mike

Edited by MikeColeman407 - 21 Apr 2015 at 8:52am
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 22 Apr 2015 at 6:53am
Go to the Select Expert, select the TRANSAMT field "is less than", type the number 0, and save.

This will filter out records that have a TRANSAMT that is greater than 0.

-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		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



This page was generated in 0.016 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.