Skip to Content
Former Member
Apr 22, 2008 at 04:05 PM

Need to sort my records by a calculated formula


Post Author: n8than1

CA Forum: Formula


I have a formula that calulates the last order date or last inventory transaction date and returns which ever date is the earliest. I'm then subtracting todays date from that date to give me the number of days since any activity. How can I sort my report by this formula? It's a number field and I have 2 groups , Location (group 1) and part number (group 2). Normally I'd use the record sort tool, but my formula field is not showing up as a sortable field.