StyleBI Documentation

InetSoftUserDocumentation

- Connect to Your Data
- Prepare Your Data
- Visualize Your Data
- Configure Self-Service
- Publish a Dashboard
- Dashboard Reference
- Advanced Dashboard Scripting
- Installation
- Manage the Server
- Advanced Server Integration
- Use the Portal

InetSoftUserDocumentation 1.0.0

InetSoftUserDocumentation
- 1.0.0

InetSoftUserDocumentation
User Functions
CALC Object Functions
Statistical Functions

Statistical Functions

The following topics present statistical functions provided by the CALC object. Each CALC function returns the same result as the Excel function of the similar name.

CALC.avedev(array)
CALC.average(array)
CALC.averagea(array)
CALC.binomdist(number_s, trials, probability_s, [cumulative])
CALC.correl(array1, array2)
CALC.count(array)
CALC.counta(array)
CALC.countblank(array)
CALC.countDistinct(array)
CALC.countn(array)
CALC.countif(array, condition)
CALC.covar(array1, array2)
CALC.devsq(array)
CALC.expondist(x, lambda, cumulative)
CALC.fisher(x)
CALC.fisherinv(z)
CALC.forecast(x, known_y_values, known_x_values)
CALC.frequency(data_array, bins_array)
CALC.geomean(array)
CALC.harmean(array)
CALC.hypgeomdist(sample_s, number_sample, population_s, number_population)
CALC.intercept(array_Y, array_X)
CALC.kurt(array)
CALC.large(array, k)
CALC.max(array)
CALC.maxa(array)
CALC.median(array)
CALC.min(array)
CALC.mina(array)
CALC.mode(array)
CALC.negbinomdist(number_f, number_s, probability_s)
CALC.nthlargest(array,n)
CALC.nthmostfrequent(array,n)
CALC.nthsmallest(array,n)
CALC.pearson(array1, array2)
CALC.percentile(array, k)
CALC.percentrank(array, x, [significance])
CALC.permut(number, number_chosen)
CALC.poisson(x, lambda, cumulative)
CALC.prob(array_x, arrayProb, lower_limit, [upper_limit])
CALC.pthpercentile(array,p)
CALC.quartile(array, quart)
CALC.rand()
CALC.randbetween(bottom,top)
CALC.rank(number, array, order)
CALC.rsq(array1, array2)
CALC.skew(array)
CALC.slope(array_y, array_x)
CALC.small(array, k)
CALC.standardize(x, mean, standard_dev)
CALC.stdev(array)
CALC.stdeva(array)
CALC.stdevp(array)
CALC.stdevpa(array)
CALC.steyx(array_y, array_x)
CALC.trimmean(array, percent)
CALC.varn(array)
CALC.vara(array)
CALC.varp(array)
CALC.varpa(array)
CALC.weibull(x, alpha, beta, cumulative)
CALC.weightedavg(array1, array2)
- Text Functions
CALC.char(number)
CALC.code(string)
CALC.concatenate(array)
CALC.dollar(number, decimals)
CALC.exact(string1, string2)
CALC.find(string1, String2, search_index)
CALC.fixed(number, decimals, no_commas)
CALC.left(string, num_chars)
CALC.len(string)
CALC.lower(string)
CALC.mid(String, start_num, num_chars)
CALC.proper(string)
CALC.replace(old_string, start_num, num_chars, new_string)
CALC.rept(string, number_times)
CALC.right(string, num_chars)
CALC.search(find_string, search_string, start_num)
CALC.substitute(old_string, rep_string , new_string, instance_num)
CALC.t(value)
CALC.text(value, format)
CALC.trim(string)
CALC.upper(string)
CALC.value(string)

Built using the Antora default UI on Wed Apr 01 2026.

The source code for this UI is licensed under the terms of the MPL-2.0 license.