Create Random Column with 15 to 25 %

[alec1982]

Need to create a column from a sales amount column to show randomly 15 to 25% for a sales column. Anyone has a quick logic

[sunny_talwar]

May be like this:

((Rand() * (0.25 - 0.15)) + 0.25) * Sales as Rand_Sales

[Clever_Anjos]

Maybe this?

Transactions:

Load

  Rand1

Where Rand1 >= 0.15 and Rand1 <= 0.25;

Load

Rand() as Rand1

Autogenerate 100000;

[alec1982]

this returns more than 25%  of the sales amount.

Thanks,

Badr

[alec1982]

my table has two columns

Transaction ID and Sales Amount

I need to add additional column for profit and it is random values of 15 to 25 % of sales amount

[sunny_talwar · Accepted solution]

My bad, it should have been this:

((Rand() * (0.25 - 0.15)) + 0.15) * Sales as Rand_Sales

[Clever_Anjos]

Transactions:

Load

[Transaction ID]

, Rand1 as [Sales Amount]

Where Rand1 >= 0.15 and Rand1 <= 0.25;

Load

Rand() as Rand1,

recno() as [Transaction ID]

Autogenerate 100000;