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.