Maths functions

AVG – Find average of values

179 views June 1, 2018 admin 0

DECTOFRAC – Convert decimal to fraction

165 views June 1, 2018 admin 1

DIV – Divide one number by another

168 views June 1, 2018 admin 0

FRACTODEC – Convert fraction to decimal

154 views June 1, 2018 admin 1

GROUPAVG – Calculate average value of field in group

181 views June 1, 2018 admin 0

GROUPCOUNT – Count groups or records in a group

557 views June 1, 2018 admin 0

GROUPCOUNTUNIQUE – Count unique instances of field content

245 views June 1, 2018 admin 0

GROUPFIRST – Identify first record in group

321 views June 1, 2018 admin 0

GROUPMAX – Identify maximum value in a group

232 views June 1, 2018 admin 0

GROUPRTOTAL – Calculate running total

201 views June 1, 2018 admin 0

GROUPSUM – Calculate total of given field in group

356 views June 1, 2018 admin 0

IF – Test if any arguments are true

1486 views June 1, 2018 admin 2

MAX – Select maximum value

130 views June 1, 2018 admin 0

MIN – Select miniumum value

109 views June 1, 2018 admin 0

MOD – Display remainder after division

102 views June 1, 2018 admin 0

MUL – Multiply two values

248 views June 1, 2018 admin 0

RANDOM – Create random number integer

207 views June 1, 2018 admin 1

ROUNDVAL – Round a given value

394 views June 1, 2018 admin 0

SUB – Subtract one value from another

162 views June 1, 2018 admin 0

SUM – Add a series of values

182 views June 1, 2018 admin 0