Why Advanced Logic Syntax is not Valid in a Report in Vault PromoMats and Medical?
Advanced Logic is a feature which allows the users to get a wider selection of records within a report. The connectors OR and AND must be used in the proper way.
There are many reasons why the syntax of the connecter is not valid:
- The filters used in the report do not have a corresponding number. These filters include roles, formula fields, and relationship concerns.
The applied filter is not counted and the syntax fails to validate.
- The selected report type does not support the Advanced Logic feature. If the report type is one of the report types listed below, the Advanced Logic feature does not appear in the Filters:
Read and Understood
- The connector AND is used in different field objects. By running the report with fields used in different objects, there are no records found in the report.
Knowledge Base: How Does Advanced Logic Work in PromoMats Reports?