Sort the report desending order

[kveni]

Hi All,

I was trying to sort the Total column in desending order but if the total is empty or space all the fields which are empty come first. The requirement is neither remove those records nor leave them on top. I want these records to be displayed at the bottom after the least value. Is this possible? if yes please let know what to do? I am using BO 6.1a full client.



Thanks
Krishna

 

[skrandel]

Change the formul in the total column to insert a 0 when the value is null.

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com