/
Conditional Formatting per Scripting
Conditional Formatting per Scripting
var areNegative = [false]; areNegative.pop(); var members = DS_1.getMembers("0D_CAT", 100); members.forEach(function(element, index) { var eleText = element.text; var value = DS_1.getData("0D_REV", { "0D_CAT": eleText }).value; var str = Convert.floatToString(value); //APPLICATION.alert(eleText + ":" + str); var isNegative = value < 0; areNegative.push(isNegative); }); var dataTypes = ""; areNegative.forEach(function(element, index) { if(element) { dataTypes = dataTypes + "PO"; } else { dataTypes = dataTypes + "NE"; } dataTypes = dataTypes + ","; }); dataTypes = dataTypes.substring(0, dataTypes.length - 1); TEXT_1.setText(dataTypes); GRAPHOMATECHART_1.setDatatypes(1, dataTypes);
Related content
RowFormatConfiguration
RowFormatConfiguration
More like this
DatatypeDictionary
DatatypeDictionary
More like this
Highlight
Highlight
More like this
SeparatorMode
SeparatorMode
More like this
Datatype
Datatype
More like this
ExtendedNumberFormat
ExtendedNumberFormat
More like this