Skip to main content

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

Was this article helpful?

We're sorry to hear that.