Reporting bug: 1 invalid formula. Please fix before switching or saving.
When editing reports we'll sometimes break formulas.
In some cases, after fixing the formulas by:
- Replacing broken elements so none are highlighted as red, or
- Literally replacing every single formula
We are still prevented from saving with the message "1 invalid formula. Please fix before switching or saving."
This isn't a new idea but a request for the dev team to revisit the validation. It's pretty inconvenient to start over.
Hi Flynn, thanks for flagging this behaviour. Sorry to hear you’re running into this error. If you’re seeing unexpected behaviour or something isn’t working as expected with report validation, it’s best reviewed more closely with your specific setup.
In these cases, we recommend raising a case with our Xero Support team via Xero Central. Our specialists can take a closer look with you and investigate what’s happening in your organisation.