Crystal Reports A number or Currency required

Report Design

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

Topic: A number or Currency required

Post Reply

Post New Topic

Author	Message
brent21090 Newbie Joined: 20 Apr 2009 Online Status: Offline Posts: 31	Topic: A number or Currency required Posted: 29 Jun 2009 at 1:17pm
	I am having problems with the formula below; {@FRemainingQty}/{OP.OP_RUN_STD} I keep getting the error a number or currency required. for the 1st field which is a formula. I have tried ({@FRemainingQty})/{OP.OP_RUN_STD} and still got the same error. Thanks
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 29 Jun 2009 at 1:23pm
	what is the formula that is for @FRemainingQty ?
	IP Logged

brent21090 Newbie Joined: 20 Apr 2009 Online Status: Offline Posts: 31	Posted: 29 Jun 2009 at 1:27pm
	The formula below is for @FRemainingQty If {@REMAININGQTY} < 0 then {@REMAININGQTY} = 0 else {@REMAININGQTY}= {@REMAININGQTY}
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 29 Jun 2009 at 1:38pm
	I cannot test this right now but a I believe you are just getting a true /false from this ... If {@REMAININGQTY} < 0 then {@REMAININGQTY} = 0 (this will always be FALSE) else {@REMAININGQTY}= {@REMAININGQTY} (this will always be TRUE) Try changing this formula to: If {@REMAININGQTY} < 0 then 0 else {@REMAININGQTY} One trick is to break things down and look at each part to make sure you are gettingt what is expected for that part of the formula. Then start adding it back togther piece by piece and test as necessary.
	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