Hi ksaibhargav, have you tried giving Number data type to the 'Profit' column.hai i used utility collection manipulation in that sort collection but i am failed to sort the collection field
but while importing the data from excel to collection all are in the text by default?Hi ksaibhargav, have you tried giving Number data type to the 'Profit' column.
any way i will add in the collection fileds and back with status?but while importing the data from excel to collection all are in the text by default?
So it is going to end up Text-based sort only.but while importing the data from excel to collection all are in the text by default?
Try checking out if there is any action in the collection vbo to do this. Also add a new number column to the collection and then inside a loop see if by using a Calc stage you can set the new collection field (number) to the old one (text).any way i will add in the collection fileds and back with status?
ya i added profit in the collection fields as number. but it showing error like unable to read the data from excel data item not mached with number typeany way i will add in the collection fileds and back with status?
See what happens if you set the Profit column in Excel itself as Number in all the cells throughout the column.ya i added profit in the collection fields as number. but it showing error like unable to read the data from excel data item not mached with number type
thnaksSee what happens if you set the Profit column in Excel itself as Number in all the cells throughout the column.
Also try the other options I have suggested above.