Conditional Sorting on Report
I have two types of records that are grouped based on a numeric field called Outbound/Inbound Report Sort: if condition 1 matches then I assign number 1 and if not, I assign number 2. After that, I wo...
Forum Discussion
This is untested but may work.
One new field: [Date for Sort]
[Date for Sort] = Formula Date field; if(Condition 1=true, [Pickup Date], Condition 2=true,"")
Sort Low to High By OutBound Inbound
Sort Low to high By [Date for Sort]
Sort High to low by [Pickup Date]
My thought is that if the Date for Sort is blank for all of condition two, they all 'tie' and then will be organized high to low by Pickup Date.
------------------------------
Michael Tamoush
------------------------------
One new field: [Date for Sort]
[Date for Sort] = Formula Date field; if(Condition 1=true, [Pickup Date], Condition 2=true,"")
Sort Low to High By OutBound Inbound
Sort Low to high By [Date for Sort]
Sort High to low by [Pickup Date]
My thought is that if the Date for Sort is blank for all of condition two, they all 'tie' and then will be organized high to low by Pickup Date.
------------------------------
Michael Tamoush
------------------------------
That worked, thanks!
------------------------------
Luis Alberto Quintanar
------------------------------
------------------------------
Luis Alberto Quintanar
------------------------------
