I’m building a Workbook to combine amounts from journal entries with quantities from statistical journals. Statistical accounts are aligned with corresponding GL accounts. The goal is an income statement by department that shows both expense amounts and related statistical quantities.
Issue:
When adding a formula to the dataset, I receive the error: “There was a problem loading your data. Please refine your query or try again later.”
Environment:
- Account type: Production
- Role: Admin-level role
Steps to Reproduce:
- Navigate to Analytics > Datasets.
- Open a dataset that joins Accounts with Transaction Accounting Lines and includes Statistical accounts.
- Go to Formulas.
- Edit the “Amount” formula with:
case when TO_CHAR({accttype#display}) = 'Statistical'
then {account<transactionaccountingline.amount#currency_consolidated}
else TO_NUMBER(NULL)
end
Actual Result:
- Error: “There was a problem loading your data. Please refine your query or try again later.”
Expected Result:
- Dataset should load and allow reporting without errors.
What I’ve Tried:
- Reviewed the following articles but they don’t seem to apply:
- 105533: Resolve error “There was a problem loading your data. Please refine your query or try again later” when adding account on Workbooks in SuiteAnalytics.
- 88134: SuiteAnalytics > Non-Admin Role > Pivot Workbook > Add Formula Field > same error.
- I’m already using {accttype#display} in the formula.
- The issue occurs in the dataset (before moving to Workbook/Pivot).
Request:
- Are there known limitations with referencing {transactionaccountingline.amount#currency_consolidated} in a CASE expression based on {accttype#display}?
- Do I need specific joins, field contexts, or aggregations to prevent this error?
- Any recommended alternative formula patterns or field references to safely handle Statistical vs non-Statistical accounts?