Crystal Reports percentage

Report Design

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

Topic: percentage

Post Reply

Post New Topic

Author	Message
walter Newbie Joined: 16 Jun 2010 Online Status: Offline Posts: 3	Topic: percentage Posted: 16 Jun 2010 at 2:36am
	When i use the attched formula trying to get the discount of 20% on the item it retuns it returns lets say the price is 22.95 it returns 1836.00 snd it should be 18.36 wbere am i going wrong if{SALES_HISTORY_DETAIL.PROD_CODE}= "fr" then {SALES_HISTORY_DETAIL.BVUNITPRICE}*80
	IP Logged


Emir_W Senior Member Joined: 25 Apr 2010 Online Status: Offline Posts: 228	Posted: 16 Jun 2010 at 2:48am
	mmm.. i think you missed "/100". so, it should be: if{SALES_HISTORY_DETAIL.PROD_CODE}= "fr" then ({SALES_HISTORY_DETAIL.BVUNITPRICE}*80)/100 hope it help. and glad if it is Edited by Emir_W - 16 Jun 2010 at 3:05am
	Emir W
	IP Logged

walter Newbie Joined: 16 Jun 2010 Online Status: Offline Posts: 3	Posted: 16 Jun 2010 at 8:44am
	Almost * 80)/100 returns a error *80/100 returns 14.99 = 17.63 so now adds 15% not discounts it any other suggestions
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 16 Jun 2010 at 11:04am
	if {SALES_HISTORY_DETAIL.PROD_CODE} = "fr" then {SALES_HISTORY_DETAIL.BVUNITPRICE}*.8
	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