Need a Random Number Formula Please

[Bobdogn]

I am still working on this so I I get an answer, I will post it.

I need a Random number between .639999999 and .64999999999

I get close but never quite get the desired result. I need a value I can use with other formulas in my report to calculate an estimated cost. Sales * Random nember = Est Cost.

Any Clues?

 

[dgillz]

The Rnd() function returns a random number between 0 and 1, but I do not know how to make it between .6399999 adn .6499999.

I suppose you could write a loop from 1 to 1,000,000 that ends if the random number is between those 2 values. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[rogar]

Come on, dgillz -- you should have seen this:

.6300000 + (rnd() * .01)

Bobdogn, check CR Help on the rnd() function and use a seed if you don't want the same value every time.

 

[Bobdogn]

The previous formula only gives me .6300000 to .63999999

I would like to try to have the ability to change the lower and upper limits incase I need to adjust sales costs.

Thanks for any and all help.

 

[dgillz]

Rogar,

you can tell its after 4pm Friday!

Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[rogar]

You can make the limits parameters with default values of .6399999 and .6499999. Then your formula would be:

{?ParmLow} + (rnd() * ({?ParmHigh} - {?ParmLow}))