invoice age formula in saved search

AI generated answer (using internal Slack threads):

Based on the conversations, to calculate the age of an invoice in a saved search, you can use a formula field. The formula would look something like this:

FLOOR(NVL({paymentdate},{today})-{invoicedate})

. This formula calculates the difference between the payment date and the invoice date. If the payment date is null, it uses the current date (

{today}

) instead. You should set the summary type of the field to 'average' and show totals for the saved search. Please note that this formula assumes that the payment date and invoice date are available in the saved search. If they are not, you may need to adjust the formula or the saved search criteria accordingly. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******