Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Nested if statement Post Reply Post New Topic
Author Message
nabilino
Newbie
Newbie
Avatar

Joined: 02 Nov 2009
Location: United States
Online Status: Offline
Posts: 25
Quote nabilino Replybullet Topic: Nested if statement
     Posted: 30 Nov 2009 at 8:56am
What's the best approach to capture the following:
 
if Days worked is >= 1800 and < 1830 then 5
else
if Days worked >=3600 and < 3630 then 10
else
if Days worked >= 5400 and 5430 then 15
 
Right now it doesn't like the AND operator and throws an Error.
IP IP Logged
FrnhtGLI
Senior Member
Senior Member
Avatar

Joined: 22 May 2009
Online Status: Offline
Posts: 347
Quote FrnhtGLI Replybullet Posted: 30 Nov 2009 at 10:26am
if Days worked>= 1800 and Days Worked< 1830 then 5
else
if Days worked>=3600 and Days Worked< 3630 then 10
else
if Days worked>= 5400 and Days Worked<5430 then 15
IP IP Logged
nabilino
Newbie
Newbie
Avatar

Joined: 02 Nov 2009
Location: United States
Online Status: Offline
Posts: 25
Quote nabilino Replybullet Posted: 30 Nov 2009 at 10:50am
Thanks a lot
IP 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