Appendix B
This appendix contains information on the calculated field patterns that are supported for RapidDecision data source-based reports in the Angles for Oracle Generator, and the calculated field patterns that are not supported.
Calculated Field Patterns for RapidDecision Data Source
Supported Calculated Field Patterns
The calculated field patterns that are supported for RapidDecision data source-based reports in the Angles for Oracle Generator are as follows:
Unique Expressions |
---|
TRIM(DataModel[COMPANY.COMPANYLEVEL01CODE])&" - "&TRIM(DataModel[COMPANY.COMPANYLEVEL01] |
DataModel[PAYMENT_TERMS.DISCOUNTPERCENT]/100.0 |
DataModel[FACTS_DETAILS.GLPOSTEDCODE] = ("P") |
DataModel[FACTS_DEPRECIATION.LEDGERTYPECODE] = "AA" |
DataModel[FACTS_DEPRECIATION.LEDGERTYPECODE] IN ("AA", "BA") |
DataModel[FACTS.RDTRANSTYPENUMID] IN (1,2) |
DataModel[ACCOUNT.ACCOUNT] >= "4000" && DataModel[ACCOUNT.ACCOUNT] <= "4999.99999999" |
TRIM(TRIM(DataModel[SOFACTS.ITEMNUMBER03])) |
TRIM(CONVERT(DataModel[PAYEE.ADDRESSNUMBER], STRING))&\"-\"&TRIM(CONVERT(DataModel[PAYEE.ALPHANAME], STRING)) |
CONVERT(DataModel[FACTS.ORDERNUMBER], STRING) |
SUM(DataModel[APFACTS.DISCOUNTAVAILABLE]) - SUM(DataModel[APFACTS.DISCOUNTTAKEN]) |
Unsupported Calculated Field Patterns
The calculated field patterns that are not supported for RapidDecision data source-based reports in the Angles for Oracle Generator. are as follows:
Expression, expression containing a keyword, expression with a keyword, or date calculated fields |
---|
Expression SUM(1) is not supported |
Expressions containing @Select, @Prompt, @Variable, or meta are not supported |
Expression with related keyword is not supported |
Expression with (CASE keyword is not supported |
Expression with SUM(( keyword is not supported |
Expression with SUMX keyword is not supported |
Date calculated fields such as Calculated Fields.Yesterday, Calculated Fields.Today, Calculated Fields.Tomorrow, Calculated Fields.PY Today are not supported |