A-B (DMATH)

Article summary

Did you find this summary helpful?

Thank you for your feedback

DMath: A-B

Use this function to:

Property	Value
FieldType	Double
FieldSize	Low / Med / High / Continuous
DataType	Discrete / Continuous
DataSize	Short / Integer / LongInteger / Double

Example Return Value: X*.XXXXXX....-X*.XXXXX

e.g.  21.000000, 98754654.123456, -5.000000, -654.320000

Parameter	JSON	Description
Table	“targetTable”: “MyTableName”	The target table on which the new field will be created
Filter	“dataset”: {DataSet_JSON}	Optional. If a filter is applied, records not in the filter recordset will be returned as null.
Math Function	“p1”: “”
A	“p2”: “NumericFieldName” “p2”: “#N.N”	Required. The minuend. Supports: DataType: Discrete / Continuous Field Type: Integer, Double Fixed Value: #N* e.g. #201596, #-87 Fixed Value: #N.N e.g. #201596.05, #-87.98
B	“p3”: “NumericFieldName” “p3”: “#N.N”	Required. The subtrahend. Supports: DataType: Discrete / Continuous Field Type: Integer, Double Fixed Value: #N* e.g. #201596, #-87 Fixed Value: #N.N e.g. #201596.05, #-87.98
Treat Null as Zero	"nullIsZero": true "nullIsZero": false	True/False. Default = False If true, then any null values in the input fields will be treated as if they have a value of 0.

Example	Details
Description	Reduce percentage by fixed amount
Input	Table: = [transactopms] Filter: = [No Filter] Function: = DMath Math Function = A-B A:= [transactions].[percent] B:= #0.25 Name: = percent_lessquarter
Sample

Was this article helpful?

Table of contents