Discussions

Expand all | Collapse all

Conditional Sorting on Report

  • 1.  Conditional Sorting on Report

    Posted 9 days ago
    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 would like to sort all Outbound/Inbound Report Sort=1 from low to high based on a date field called Pick Up Date but also sort all Outbound/Inbound Report Sort=2 from high to low.


    This is the desired result:



    ​​

    ------------------------------
    Luis Alberto Quintanar
    ------------------------------


  • 2.  RE: Conditional Sorting on Report

    Posted 9 days ago
    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
    ------------------------------



  • 3.  RE: Conditional Sorting on Report

    Posted 8 days ago
    That worked, thanks!

    ------------------------------
    Luis Alberto Quintanar
    ------------------------------