Crystal Reports need help with formula?

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: need help with formula?

Post Reply

Post New Topic

Author	Message
nitrotech Groupie Joined: 30 Jan 2013 Location: United States Online Status: Offline Posts: 42	Topic: need help with formula? Posted: 08 Feb 2013 at 4:36am
	Hi have a report that needs to filter all Employee ID with an R in them. The employee id is 6 character in length If the id does not have an R in it I want the value to be 60 if it has an R in it I have a formula to caculate its value? Need help with this formula thanks
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 08 Feb 2013 at 4:38am
	if table.employeeid like 'R' then 60 else your calculation
	IP Logged

nitrotech Groupie Joined: 30 Jan 2013 Location: United States Online Status: Offline Posts: 42	Posted: 08 Feb 2013 at 4:47am
	I ran that command and It did just the opposite anything with an r it gave 60 and thingwith out the r it did the calculation is their and unlike command? thanks
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 08 Feb 2013 at 5:50am
	sorry I misread your request. if not(table.employeeid like 'R') then 60 else your calculation
	IP Logged

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