Calculation text
"Calculation text" performs calculation specified immediately after reading and just before writing in a card, and makes the result reflect to this. It cannot input a value directly.
SQL definition*1 | |
Integer | INTEGER |
Currency | DECIMAL(18,4) |
Double | DOUBLE PRECISION |
- Formula
Inputs a formula. You can use a numerical value, four operations(Add:+,Subtract:-,Multiply:*,Divide:/), a parenthesis(only"()"), and the following functions for a formula.
ABS(num) Returns the absolute value. ACOS(num) Returns the arc cosine. ASIN(num) Returns the arc sine. ATAN(num) Returns the arc tangent. ATAN2(num,num) Returns the angle whose sine-to-cosine ratio is given by the two arguments. CEIL(num) Returns the smallest whole number greater than or equal. COS(num) Returns an angle's cosine. COSH(num) Returns the hyperbolic cosine. COT(num) Returns an angle's cotangent. EXP(num) Returns the natural exponential(enum). FLOOR(num) Returns the largest whole number smaller than or equal. LN(num) Returns the natural logarithm. LOG(x,y) Returns the x-based logarithm of y. LOG10(num) Returns the 10-based logarithm. MAXVALUE(val[,val...]) Returns the maximum value from a list of numerical. MINVALUE(val[,val...]) Returns the minimum value from a list of numerical. MOD(num,num) Returns the remainder of an integer division. PI Returns an approximation of the value of π. POWER(x,y) Returns x to the y'th power. RAND() Returns a random number between 0 and 1. ROUND(num[,num]) Rounds a number to the nearest integer. SIGN(num) Returns the sign of the argument: -1, 0 or 1. SIN(num) Returns an angle's sine. SINH(num) Returns the hyperbolic sine. SQRT(num) Returns the square root. TAN(num) Returns an angle's tangent. TANH(num) Returns the hyperbolic tangent. TRUNC(num[,num]) Returns the integer part of a number.
When a formula has parts name, the value written down in that item is assigned*2. In an internal list, it is merging the following functions and "Parts.SubParts(.category)", and is calculated to all the cards of a list.
AVG Average SUM Sum COUNT Count MIN Minimum MAX Maximum STDDEV Standard deviation STDDEV_SAMP Sample standard deviation VARIANCE Variance VAR_SAMP Sample variance
For example, if it is "SUM(listparts.score)", the sum of items "score" in the card list currently displayed on "listparts" will be substituted. And if it is "AVG(listparts.score.'Food'*3", it will be displayed on "listparts" and the average value of the "score" item of the card whose value of a category attribute is "Food" will be substituted. - Culcuration type
Specifies the type of a calculation result. The minimum and maximum of a value are the same as that of the type of Simple text. - Store in database
Records a calculation result to the database. Thereby, probably it omits the calculation process on and after next time, and will be able to get a value quickly.