Hi, I have some forms which contain calculated fields. Is there an easy way of getting these calculated fields to show in a saved search?

As far as I know, no, since the data is not stored in the database. But if there is a way, I'd like to know too. 🙂

You will need to move those calculations to a SuiteScript or Workflow. So the fields can actually save those values.

Thanks, I'll give that a go!

Calculated fields often work in searches for me - reports they definitely don't though

Now that @KevinJ of Kansas has mentioned it, I also remember calculated fields showing up in results. Give it a try @BullgillRunner

I can get calculated fields to work if all the fields required for that calculation are available on the document/form in question but if the calculated field gets its result from a saved search, then I can't pull this figure through. Big limitation in NetSuite, other products I've used would have no problem with this. I'll keep battling and come up with a solution although I doubt it will be as smooth as I'd like.

You will need to move those calculations to a SuiteScript or Workflow.

Oh that's a saved search field, which is not a calculated field. - Normally what I do to facilitate this is create a secondary field - and then use a scheduled workflow to push the values in. Of course, by the time I do that, I'm pretty close to the amount of time it would take to script it. Or I switch to doing the calculation in a script or workflow and plugging it into a stored value field.