I have a report that when I run it with batch function execution enabled, it finishes almost immediately with all cells showing #VALUE!
Support advised me previously of two things;
1. add "@@"& to NL functions that reference filters that may be in error to prevent the batch from failing
2. turn off BFE, run the report and search for cells in error.
In this particular instance, the former doesn't seem to help, and when doing the latter, I cannot find any cells in error.
I have a ticket open with support but this is currently on hold as our support is undergoing renewal, so I was wondering if anyone might have any advice for me in the meantime on how to go about diagnosing and fixing?