Go to start of banner

# Formula operator: General Mathematics

## General Mathematics

Function/PropertyExampleDescription
-#A# - #B#Subtraction
/#A# / #B#Division
*#A# * #B#Multiplication
%#A# % #B#A modulo B

Write the constant with decimal places --> 7.0 if an operation is supposed to yield a number with decimal places and you are working with constants.

Example:

The result is defined as a number with decimal places

Case 1: `10 / 3` results in `3.0`

Case 2: `10 / 3.0` results in `3.33`

### Built-In C# Functions of System.Math

FunctionReturn ValueResult
`System.Math.Abs(d)`

Number with decimal places

Number without algebraic sign (absolute value of d)

`System.Math.Floor(d)`

Integer

Yields the largest integer equal to or less than the input value (d).

`System.Math.Ceiling(d)`

Integer

Yields the smallest integer equal to or greater than the input value (d).

`System.Math.Round(a,n)`

Number with decimal places

Rounds a double-precision floating-point value (a) to a specified number (n) of fractional digits.

Please note: to round half away from zero (e.g., round 23.5 to 24, and 23.4 to 23) use

`System.Math.Round((double)#C#, System.MidpointRounding.AwayFromZero)`
`System.Math.IEEERemainder(a,n)`

Remainder of a division

Divides a by n and returns the remainder

`System.Math.Log(a)`

Number with decimal places

Yields the logarithm of a

`System.Math.Log10(a)`

Number with decimal places

Yields the base 10 logarithm of a

`System.Math.Log(a,b)`

Number with decimal places

Yields the base b logarithm of a

`System.Math.Max(a,b)`

Number with decimal places

Yields the maximum of a and b

`System.Math.Min(a,b)`

Number with decimal places

Yields the minimum of a and b

`System.Math.Pow(x,y)`

Number with decimal places

Calculates the exponentiation of base x and exponent y (xy)

`System.Math.Sqrt(d)`

Number with decimal places

Calculates the square root of d

`System.Math.Sign(d)`

Number with decimal places

Yields the algebraic sign of d

`System.Math.Sin(d)`

Number with decimal places

Sinus of d

`System.Math.Cos(d)`

Number with decimal places

Cosinus of d

`System.Math.Truncate(d)`

Number with decimal places

Yields the integral portion of d

Additionally, Sin, Cos, Tan, Sing, Cosh, Tanh, Asin, Acos, Atan, PI and E are available, see also MSDN

### More Examples

Question

Code

Number of values in pivot

7 times single field in e.g.

`"N Mo" with #Mo# > 0 ? 1:0 `

and then field for total with

`#N MON# + #N TUE# + #N WED# + #N THU# + #N FRI# + #N SAT# + #N SUN#`

Calculate sum in pivot table

#MON# + #TUE# + #WED# + #THU# + #FRI# + #SAT# + #SUN# ...