Calculated Values

Calculated Values - Overview
Calculated values are a powerful way to extend the functionality of a SharpCloud story, by adding new insight into the data. They are similar to the cell ca...
Tue, 2 Mar, 2021 at 6:37 PM
Calculated Values Index
Below is a list of ALL available calculated value functions and properties. Click on any function or property name to go to it's respective article for...
Fri, 26 Feb, 2021 at 7:22 PM
Calculated Values - Data Types
There are 5 Calculated Values data types that can be created and implemented in SharpCloud.   Number   Date Text Boolean  Array   Number    An i...
Tue, 28 Jul, 2020 at 3:23 PM
Arithmetic Operators
Arithmetic operators are used to perform arithmetic on numbers (or strings).   Operator Description Works with: + Addition Numbers - ...
Tue, 28 Jul, 2020 at 3:26 PM
Comparison and Logical Operators
Comparison and Logical operators can be used in the IF function. They are used to compare two values. Return Values True or False Operator D...
Tue, 28 Jul, 2020 at 3:30 PM
Parenthesis Operators
Different ‘bracket’ types have different meanings depending on how they are used.   Parentheses (normal brackets) can change the order in which a formula ...
Tue, 28 Jul, 2020 at 3:32 PM
IF Function
Function(s) IF(condition, true_result, false_result) The IF function is probably the simplest and most powerful calculated function. It allows you to test...
Fri, 19 Feb, 2021 at 6:59 PM
Get Item Value (GETITEMVALUE)
Description   GETITEMVALUE is a powerful function which is used to return a value of an attribute/calculated value that another item hold. The calculation...
Tue, 28 Jul, 2020 at 3:34 PM
Get Item Values (GETITEMVALUES)
Description   GETITEMVALUES is a powerful function which is used to return a value of an attribute/calculated value that other items hold. The calculation...
Tue, 28 Jul, 2020 at 3:35 PM
Category (category)
The category property is a SharpCloud specific property that all attributes possess, denoting what category an item is assigned to.    You can reference t...
Tue, 28 Jul, 2020 at 3:36 PM