Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Reports with Progression Explorer

Status
Not open for further replies.
mcole22

mcole22

Technical User
Apr 27, 2007
6
US
I need a formula like below, just not sure what to put after the else.

if {IMRECHST_SQL.qty_received} is <=0 then 0 else (in this I want the actual amount received {IMRECHST_SQL.qty_received}

What I am getting in the received qty is, if the qty was received it is showing -450 and if it hasn't been received it is showing 450 and I want this latter part to show 0.

I tried it like this - if {IMRECHST_SQL.qty_received}<= 0 then 0 else {IMRECHST_SQL.qty_received}. But it came up with this error - The formula result must be a boolean
 
Status
Not open for further replies.

Similar threads

JOEYB99
  • Locked
  • Question
Problem with Webi Hyperlink to SAP t-code CATS_DA
Replies
0
Views
301
JOEYB99
JOEYB99
t1sugar
  • Locked
  • Question
which version of crystal reports for boxi 4.1; Help 1
Replies
3
Views
349
hilfy
hilfy
Eaglewhite
  • Locked
  • Question
Find Reports in BOXI
Replies
1
Views
123
kray4660
kray4660
Pookeye
  • Locked
  • Question
Running Crystal Reports in Business Objects 4.1 with Universe as a Datasource.
Replies
0
Views
87
Pookeye
Pookeye
amadese
  • Locked
  • Question
BO reports - Universes - dynamic column
Replies
0
Views
95
amadese
amadese

Part and Inventory Search

Sponsor

Back
Top