3958578 Newbie

Thanks for replying, Mon. The formula on the summary tab is meant to distribute the results to users. In order for the search to be useful on the dashboard, users should see only their own items rather than the whole list. There's nothing wrong with the result, per se, it's just the whole list and I don't want users to…

To follow up on this, in case anybody is interested: I set a summary criteria of the following: [case when max({custrecord63})KEEP(dense_rank last order by {created}) = {user.entityid} then 1 else 0 end] must equal 1 This, unfortunately gives an unexpected error. I spoke with Netsuite support and they were unable to…

Have you tried using KEEP with DENSE_RANK to find the backordered amount for only the most recent entry? This article explains it better than I would be able to: https://netsuite.custhelp.com/app/answers/detail/a_id/23066/kw/search%20most%20recent Hope that works for you.

This would be a great feature for us. Is there an enhancement request in for this?

This isn't possible with financial reports, is that correct?