Applicability
This error applies to the following situation:
Impact
This error prevents you from running calculations.
Explanations
In formulas, you can use your own SQL to query credited transactions and calculated rewards (examples). We provide full data isolation / sandboxing by making a copy of your workspace data to a private database. Your SQL query only runs against your own private database.
On the other hand, formulas with {{...}} are direct SQL queries which operate directly on our entire database. Those formulas are configured by the Sales Cookie team for cases where isolation and sandboxing is not sufficient or too slow, or because we need to refer to other entities.
Only Sales Cookie operators can alter direct SQL queries. If you alter a formula with a direct SQL query, our system will detect this change and issue error "Your plan contains advanced formulas which must be approved by us. Please contact support for assistance.".
Here is an example of a direct SQL query:
{{SELECT SUM([Amount (Imported)]) FROM Transactions}}
Resolution
As instructed by the error, please contact technical support. We will review your formulas and authorize changes after evaluating their performance impact.