autonumber?

[#1]

autonumber(sales)*100 as nsales  ?   what it returns ?

[saurabh5]

it will give you the output as 100,200,300 depending on the distinct rows of sales you have in your data.

Regards

Saurabh

[MK_QSL · Accepted solution]

It will AutoNumber each distinct Sales with 1, 2 ,3 ,4 etc.. and then multiply with 100

So if you have

Sales as

100

100

100

120

120

130

it will give

Sales     nsales

100         100

100         100

100          100

120          200

120          200

130          300