Crystal Reports Formula Help...

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Formula Help...

Author	Message
kabutter Newbie Joined: 10 Apr 2012 Location: United States Online Status: Offline Posts: 1	Topic: Formula Help... Posted: 10 Apr 2012 at 5:46am
	I would like to write a formula to exclude data from a summary report... If the payer category is Medicare, exclude the remark codes that end in 22. Right now i have the formula set to exclude *all* remark codes ending in 22. Report Fields: {C1_REMARK_CD} {C1_PAYER_CATEGORY} Using Crystal Reports 10 Thanks in advance for the help!
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	Posted: 10 Apr 2012 at 8:15am
	if {C1_PAYER_CATEGORY} = "medicare" and right({C1_REMARK_CD}, 2) = "22" then 0 else {table.field} then sum on the formula....or you could create a shared variable and calculate it doing much the same logic. HTH
	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.