This section provides an overview of the calculation syntax used within the Coins ERP+ Toolset and provides some examples of its use.
Calculations can take place on any Database field and/or include any conditions required to produce a desired result. This section basically splits calculations down into three major areas.
Calculations on Numerical Values
Calculations on Character Values
Calculations on Date Values
There are various areas in the BI toolset where calculations are utilised and the syntax used is consistent across all of these. Some of the areas where calculations can be used are as follows:-
Report Writer
Field Definition
Report Designer
Field Definition
Initial Calculation
Pre Report Calculation
Post report Calculation
Calculate Condition
Page Designer
Field Definition
Initial Calculation
DataSets
Field Definition
Initial Calculation
Pre Report Calculation
Post report Calculation
DataMarts
Column Definition
Workflow
Initialisation
Stages