{"type":"doc","content":[{"type":"paragraph","content":[{"text":"Custom Operators","type":"text","marks":[{"type":"strong"}]}]},{"type":"table","content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Type","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Operator","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Example","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Numerical Operators","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"+-*/:basic operators","type":"text"},{"type":"hardBreak"},{"text":" % : Modulo operator","type":"text"},{"type":"hardBreak"},{"text":" ^ : Power operator","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"(-1 + 50*2 ) / ( 2^4 )","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Boolean operators","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"~, xor : operators","type":"text"},{"type":"hardBreak"},{"text":" &&, and : And operators","type":"text"},{"type":"hardBreak"},{"text":" ||, or : Or operators","type":"text"},{"type":"hardBreak"},{"text":" !, not : Not operators","type":"text"},{"type":"hardBreak"},{"text":" < : less operator","type":"text"},{"type":"hardBreak"},{"text":" > : great operator","type":"text"},{"type":"hardBreak"},{"text":" <= : less or equal operator","type":"text"},{"type":"hardBreak"},{"text":" >= : great or equal operator","type":"text"},{"type":"hardBreak"},{"text":" ==, equals : equal operators","type":"text"},{"type":"hardBreak"},{"text":" !=, <> : not equal operators","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"text":"!(A && (B < 10)) | NOT ( A XOR ( B equals C ) )","type":"text"},{"type":"hardBreak"},{"text":" A != 2 || B > 2","type":"text"},{"type":"hardBreak"},{"text":" \"string1\" == \"string2\"","type":"text"},{"type":"hardBreak"},{"text":" A or B","type":"text"},{"type":"hardBreak"},{"text":" A or ( B <> C )","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"String operators","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"== : 2 strings equals","type":"text"},{"type":"hardBreak"},{"text":" != : 2 strings not equals","type":"text"},{"type":"hardBreak"},{"text":" <> : 2 strings not equals","type":"text"},{"type":"hardBreak"},{"text":" < : The first string less lexically than ","type":"text"},{"type":"hardBreak"},{"text":" the second one","type":"text"},{"type":"hardBreak"},{"text":" > : The first string great lexically than","type":"text"},{"type":"hardBreak"},{"text":" the second one","type":"text"},{"type":"hardBreak"},{"text":" <= :The first string less or equals lexically than ","type":"text"},{"type":"hardBreak"},{"text":" the second one","type":"text"},{"type":"hardBreak"},{"text":" >= : The first string great or equals lexically than ","type":"text"},{"type":"hardBreak"},{"text":" the second one","type":"text"},{"type":"hardBreak"},{"text":" + : Concat string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"\"string1\" == \"string2\" : false","type":"text"},{"type":"hardBreak"},{"text":" \"string1\" + \"a\" : \"string1a\"","type":"text"},{"type":"hardBreak"},{"text":" \"abc\" > \"aaa\" : true","type":"text"},{"type":"hardBreak"},{"text":" \"zyx\" < \"bcd\" : false","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"List operators","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"+ : Concat two lists","type":"text"},{"type":"hardBreak"},{"text":" - : Substract a list to another one","type":"text"},{"type":"hardBreak"},{"text":" in : Test if an element is inside a list","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"(1,2)+(3,4) = (1,2,3,4)","type":"text"},{"type":"hardBreak"},{"text":" (1,2) + 3 = (1,2,3)","type":"text"},{"type":"hardBreak"},{"text":" 3+(1,2)=(1,2,3)","type":"text"},{"type":"hardBreak"},{"text":" (1,2,3,4)-(3,4)=(1,2)","type":"text"},{"type":"hardBreak"},{"text":" (1,2,3,4)-3=(1,2,4)","type":"text"},{"type":"hardBreak"},{"text":" 2 in (1,2,3)=true","type":"text"},{"type":"hardBreak"},{"text":" 4 in (1,2,3)=false","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Other operators","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"= : set a variable operator","type":"text"},{"type":"hardBreak"},{"text":" [] : absolute value","type":"text"},{"type":"hardBreak"},{"text":" ² : power 2 operator","type":"text"},{"type":"hardBreak"},{"text":" % : Percent operators","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"A = [ 2 - A ] * 2","type":"text"}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"text":"2²","type":"text"},{"type":"hardBreak"},{"text":" 10%=0.1","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Conditional operators","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"if then","type":"text"},{"type":"hardBreak"},{"text":" if then else","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"if ( A > 2 ) then (\"Ok\")","type":"text"},{"type":"hardBreak"},{"text":" if ( A <=2 ) THEN (B=3) else (B=4)","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Custom functions","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Described below","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":" ","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"text":"Custom Functions","type":"text","marks":[{"type":"strong"}]}]},{"type":"table","content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Name","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Function signature","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"format","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Formats decimal number. Default format is #.##.","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"format (n) - returns the decimal number n in the format '#.##'.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"number","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Parses string to number (double).","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"number (s) - parses the string v as a double.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"timeformat","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Formats a number as date/time string. Default time format is \"MM/dd/yyyy HH:","type":"text"},{"text":"mm:ss.SSS","type":"text","marks":[{"type":"link","attrs":{"href":"http://mmss.SSS"}}]},{"text":"\".","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"timeformat (n,f) - formats the double value n to the date/string f","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"mapput","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Puts a key/value pain in a map. If the given map was not declared prior to this function, then this function creates it.","type":"text"}]},{"type":"paragraph","content":[{"text":"Note: the function returns the result map.","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"mapput (m,k,v) - returns the new map m after putting the value v using the key k.","type":"text"}]},{"type":"paragraph","content":[{"text":"mapput(m,m2) - Returns the new map m after putting the map m2 in it.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"mapget","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Returns a value from a map using a key.","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"mapget (m,k) - returns the value in m to which the key k is mapped.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"mapkeys","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Returns all the map's keys.","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"mapkeys (m) - returns all the keys of map m.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"mapvalues","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Returns all the map's values.","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"mapvalues (m) - returns all the values of map m.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"mapremove","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"removes a mapping from a map using a key","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"mapremove (m,k) - removes from the map m the mapping for key k, if present.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"listget","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"returns the element in a list at a specified position","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"listget (l,i) - returns the element at position i in list l.","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"text":"Custom Aggregation Functions","type":"text","marks":[{"type":"strong"}]}]},{"type":"table","content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Name","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Function Signature","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"aggAvg","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"returns the aggregated average value of a parameter.","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"aggAvg (p) - returns the aggregated average value of given parameter p.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"aggSum","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"returns the aggregated sum value of a parameter.","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"aggSum (p) - returns the aggregated sum value of given parameter p.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"aggSum","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"returns the aggregated sum value of a parameter.","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"aggSum (p) - returns the aggregated sum value of given parameter p.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"aggMax","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"returns the aggregated max value of a parameter.","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"aggMax (p) - returns the aggregated max value of of given parameter p.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"aggMin","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"returns the aggregated min value of a parameter.","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"aggMin (p) - returns the aggregated min value of given parameter p.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"mapAggAvg","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"returns aggregated avg map","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"mapAggAvg (k,v) - returns map that each value v is aggregated avg result","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"for given key k.","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"mapAggSum ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"returns aggregated sum map","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"mapAggSum (k,v) - returns map that each value v is aggregated sum result for given key k.","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"text":"Custom Basic Functions","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"random - A random value from 0 to 1.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"strlen - Compute the length of a string.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"sqrt - Square root .","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"avg - The average of the arguments.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"cos - Cosine with a radian argument.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"acos - Arc cosine with a radian argument.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"asin - Arc sine with a radian argument.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"atan - Arc tan with a radian argument.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"exp - Compute the euler's number e raised to the power of the argument.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"floor - the largest (closest to positive infinity) double value that is less than or equal to the argument and is equal to a mathematical integer.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"int - Convert the double argument to integer.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"logn - Natural logarithm in n base : logn( BASE, VAL).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"log 10 - Natural logarithm in 10 base.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"log - Natural logarithm in e base.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"pow - The first argument power the second one.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"prod - The product of the arguments.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"round - The closest long to the argument.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"sin - Sine with a radian argument.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"tan - tan with a radian argument.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"degTorad - Convert angle from degrees to radians.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"radTodeg - Convert angle from radians to degrees.","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"text":"Complete syntax can be found here: ","type":"text"},{"text":"http://www.japisoft.com/formula/doc/index.html","type":"text","marks":[{"type":"link","attrs":{"href":"http://www.japisoft.com/formula/doc/index.html"}}]}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]}],"version":1}

Browser not supported