How to fix this problem: I have a formulatext result column on a saved search. If it has no Summary type, then I get "ERROR: Field value cannot be derived from search with no summary type." on the unstored field that is using that search to set its default value. But if I put "Minimum" as the summary type, then I get "ERROR: Field value cannot be derived from search" That error message seems misleading as to what the real problem is.

AI generated answer (using internal Slack threads):

Based on the conversations, it seems like the issue you're encountering is due to the use of a formula in a saved search without a proper summary type. When you're using a formula in a saved search, you need to ensure that the summary type is compatible with the formula. For instance, if you're trying to sum up two different columns, you need to use a summary type like 'Maximum' and your formula should look something like this:

SUM(column1) + SUM(column2)

. If you're using a formula with a 'group' summary type, you need to ensure that your formula doesn't contain a long text field as they are not supported by the group summary type. In case you're using a formula with a 'Maximum' summary type, you need to ensure that you're not using two different summary types at the same time. For example, if you're trying to subtract one field from the sum of another field, your formula should look something like this:

SUM({custrecord161})-{custrecord154.shippingcost}

. Also, make sure that the fields you're using in your formula are of the same type and they're both numeric. NetSuite sometimes throws unexpected errors on type mismatches. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******