Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
autonumber(sales)*100 as nsales ? what it returns ?
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
it will give you the output as 100,200,300 depending on the distinct rows of sales you have in your data.
Regards
Saurabh
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