(A-B)/C

Article summary

Did you find this summary helpful?

Thank you for your feedback

DMath: (A-B)/C

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-B)/C”	(A-B)/C
A	“p2”: “NumericFieldName” “p2”: “#N.N”	Required. Numeric Input for A 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. Numeric Input for B 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
C	“p4”: “NumericFieldName” “p4”: “#N.N”	Required. Numeric Input for C Supports: DataType: Discrete / Continuous Field Type: Integer, Double Fixed Value: #N* e.g. #201596, #-87 Fixed Value: #N.N e.g. #201596.05, #-87.9 If C = 0, then (A-B)/C will return NULL
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	Divide difference of A minus B by C
Input	Table: = [customer] Filter: = [No Filter] Function: = DMath Math Function = (A-B)/C A:= [customer ].[Input_A] B:= [customer ].[Input_B] C:= [customer ].[Input_C] D:= [customer ].[] Name: =
Sample

Was this article helpful?

Table of contents