Calculated Values

To Array (TOARRAY)
Note: This function is available in SharpCloud v9.2.0408 and later. TOARRAY function is used to convert a string into an array data type. This can be us...
Wed, 29 Jul, 2020 at 12:46 PM
GETRELATIONSHIPVALUES
Note: This function is only available on SharpCloud v9.7.0217 and later Function(s) GETRELATIONSHIPVALUES(itemIdentifier, codeValue) GETRELATIONSHIPVALUE...
Wed, 17 Feb, 2021 at 10:01 PM
STDEV
Note: This function is only available on SharpCloud v9.7.0217 and later Function(s) STDEV(arrayOfValues) The standard deviation of an array of numbers ca...
Fri, 19 Feb, 2021 at 7:00 PM
relsfrom
Function(s) relfrom relsfrom is a function used to return the number of items that are related to the selected item with a direction of “From”. Syntax r...
Fri, 19 Feb, 2021 at 7:01 PM
relsto
Function(s) relsto relsto is a function used to return the number of items that are related to the selected item with a direction of “To”. Syntax relsto...
Fri, 19 Feb, 2021 at 7:01 PM
relsnone
Function(s) relsnone relsnone is a function used to return the number of items that are related to the selected item with a direction of “None”. Syntax ...
Fri, 19 Feb, 2021 at 7:01 PM
relsboth
Function(s) relsboth relsboth is a function used to return the number of items that are related to the selected item with a direction of “Both”. Syntax ...
Fri, 19 Feb, 2021 at 7:02 PM
itemtype
Function(s) itemtype itemtype is a property which can be used to differentiate between the item types of local, inherited, shared and dynamic when using a...
Fri, 26 Feb, 2021 at 7:19 PM
storyid
Function(s) storyid storyid is a property which will return the ID of the source story. Items in an Enterprise Solution may be sourced from various storie...
Fri, 26 Feb, 2021 at 7:19 PM
Calculated Value Groups and Included In
 Note: This feature is available in SharpCloud v9.7.0303 and later   Calculated Value Groups   Assigning attributes/calculated values to groups provides...
Tue, 2 Mar, 2021 at 6:46 PM