What does the floor formula do in the transactions saved search?

AI generated answer (using internal Slack threads):

The FLOOR formula in a transactions saved search in NetSuite is used to round down a number to the nearest integer. In the context of the provided conversation, the formula

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

is used to calculate the number of days between the invoice date and the payment date (or the current date if the payment date is null). The FLOOR function ensures that the result is an integer by rounding down any decimal values. The NVL function is used to replace null values. In this case, if the payment date is null, it is replaced with the current date (

{today}

). The difference between the payment date (or the current date) and the invoice date is then calculated. The FLOOR function rounds this value down to the nearest whole number. The summary type of the field is set to 'average' to calculate the average number of days it takes for an invoice to be paid. The 'show totals' option for the saved search would then display the total average across all transactions. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******