2022.2

Note: Thevaluemustbeallinlowercase:true,false.Anyvariationincase(True,TRUE)will
notwork.
Boolean expressions
Booleanvaluescanbesetusinganexpressionofwhichtheresultistrueorfalse.Thisisdoneusing
operatorsandcomparisons.
Example:record.fields["isCanadian"] = (extract("Country") == "CA");
FormoreinformationonJavaScriptcomparisonandlogicaloperators,pleaseseew3schools.comor
developer.mozilla.org.
Currency
TheCurrencydatatypeisasigned,numeric,fixed-point64-bitnumberwith4decimals.Valuesrange
from-922337203685477.5808to922337203685477.5808.Thisdatatypeisroutinelyusedforfin-
ancialcalculations:itisaspreciseasintegers.
Defining Currency values
l
Preprocessor:
l
IntheStep propertiespane,underProperties,addorselectafield.
l
SpecifytheTypeasCurrencyandsetadefaultvalueasanumberwithupto4decimal
points,followedbyasemicolon;suchas546513.8798;
l
Extraction:ThefieldvaluewillbeextractedandtreatedasaFloat.
l
IntheData Model,selectafield.
l
OntheStep propertiespane,underField DefinitionsettheTypetoCurrency.
l
UnderData Format,specifyhowthevalueisformattedinthedatasource(see"Extract
stepproperties"onpage326;forthedefaultformatsettings,see"Datasourcesettings"on
page223).
l
JavaScript Expression:SetthedesiredvaluetoanyFloatvalue.
Example:record.fields["PreciseTaxSubtotal"] = 27.13465;
Note: WhileCurrencyvaluescanbesettoupto4significantdigits,only2aredisplayedon
screen.
Page 277