Hello,

I am looking for a formula to round a calculated price and subtract a cent.
I want it to calculate a new price based off of gross margin and using the new cost.

So I use:

New Cost / (1-GM%) = New Price (Works fine)

I want it to calculate and then do this:

If New Price < $5.00 Round Up to the nearest (10 cents) and subtract 1 cent.
I. E. (If $4.22) then New Price rounds up to $4.30-.01=$4.29

If New Price > $5.00 Round Up to the nearest (dollar) and subtract 1 cent.
I. E. (If $5.65) then New Price rounds up to $6.00-.01=$5.99

How can I do this all in one formula and have it calculate the original formula but print the new price based on the 2 IF statement?

Any direction towards this would be great.

I use Crystal Reports 9.

Thanks,

Corey



Edited by Corey99 - 17 Aug 2011 at 5:09am

Thanks for the quick response.

Can I use it in the formula workshop? Or what way can I do this.

I have placed this in the formula workshop for New Price

whileprintingrecords;

local numbervar nNewPrice;
local numbervar nRoundedPrice;

local numbervar nNewPrice:= {Sheet1_.Cost} / (1-{@GM%});

local numbervar nRoundedPrice:=if nNewPrice <5
     then RoundUp(nNewPrice,1)-.01
          else RoundUp(nNewPrice)-.01;

nRoundedPrice;

Says I am missing a number, currency amount, boolean, date, time, date-time, or string. Highlights the RoundUp after the then.

What am I missing?

hmmmm...could possibly be that the RoundUp function isn't available in CR9. I am using CR2008 so that could have something to do with it. While in the Formula Editor, look under The Math Function and see if RoundUp is there. If not, we may have to look for another solution.