Common Errors
Formula Returns 0
Possible causes
Account number doesn't exist in NetSuite
No transactions were posted for that account in the specified period
Filters are too restrictive — wrong subsidiary, department, or other dimension
Solution
Verify the account exists in NetSuite and has activity for the period. Try removing filters one at a time to isolate the cause.
Formula Shows #BUSY
Cause
XAVI is currently fetching data from NetSuite.
Solution
Wait a few seconds. If it persists, check your internet connection. A stable connection is required for XAVI to communicate with NetSuite. One exception is balance sheet accounts, which take longer to calculate since they need to sum up amounts from the beginning of time.
Formula Shows #VALUE!
Cause
One or more parameters are in an invalid format.
Solution
Check that:
The account is a number or valid wildcard pattern (e.g.,
"4010"or"4*")Period format is correct (e.g.,
"Jan 2025"— not"January 2025"or"01/2025")Skipped filter parameters use
""as a placeholder, not a missing comma
All Formulas Return 0 Suddenly
Possible causes
Temporary server connection issue
The tunnel URL has changed
Solution
Click Refresh All in the task pane — this clears the cache automatically
Check the connection status indicator in the task pane
If the connection shows as disconnected, contact your administrator
Slow Performance
Solutions
Use wildcards for summary rows instead of individual account formulas (e.g.,
"6*"instead of 20 separate accounts)Drag formulas instead of typing each one — dragging triggers XAVI's batch optimization, which can consolidate 60+ formulas into a single API call
Group similar formulas together on the sheet so they are batched more efficiently
Need More Help?
🔍 Visit the Help Center: https://www.cloudextend.io/support/
💬 Use the in-app chat
✉️ Email cloudextend-support@celigo.com