{"id":3650,"date":"2015-10-12T13:26:12","date_gmt":"2015-10-12T05:26:12","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=3650"},"modified":"2024-07-04T15:41:41","modified_gmt":"2024-07-04T07:41:41","slug":"calculations","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/calculations\/","title":{"rendered":"Calculations"},"content":{"rendered":"
\n
Syntax<\/span>
\nGeneral syntax\u00a0rules for calculations, and how the functions work.<\/span><\/a><\/div>\n
Keywords<\/span><\/a><\/p>\n
E
\nEntity
\nLog10E
\nLog2E
\nNull
\nPi
\nSystemTime
\nTrue
\nFalse<\/div>\n<\/div>\n
Operators<\/span>
\nOperators available for use in calculations, and how they are used.<\/span><\/a><\/div>\n<\/div>\n

Functions List<\/h2>\n
\n
Cast<\/span><\/p>\n
Boolean<\/a>
\nDateTime<\/a>
\nDecimal<\/a>
\nDuration<\/a>
\nFormat<\/a>
\nInteger<\/a>
\nMakeDateTime<\/a>
\nNumberToString<\/a>
\nParseDate<\/a>
\nString<\/a><\/div>\n<\/div>\n
Conditional Logic<\/span>
\n If<\/a>
\nSingleValueIf<\/a>
\nSelect<\/a>
\nSwitch<\/a>
\nSingleValueSwitch<\/a>
\nTableLookup<\/a><\/span><\/div>\n
Confidence Functions<\/span>
\nConfidence<\/a>
\nConfidenceCutoff<\/a><\/span><\/div>\n<\/div>\n
\n
Data Dictionary<\/span><\/p>\n
DDAverage<\/a>
\nDDCount<\/a>
\nDDGet<\/a>
\nDDGetAttributes<\/a>
\nDDGetEntities<\/a>
\nDDGetParent<\/a>
\nDDHasTemplate<\/a>
\nDDMax<\/a>
\nDDMin<\/a>
\nDDStdDev<\/a>
\nDDSum<\/a><\/div>\n<\/div>\n
Date-Based Functions<\/span>
\nCalendar Periods
\nMonths
\nProduction Periods<\/span><\/a><\/div>\n
Digital State<\/span>
\nNumberToState<\/a>
\nStateToNumber<\/a><\/span><\/div>\n<\/div>\n
\n
Error Handling<\/span><\/p>\n
CatchError<\/a>
\nCatchNull<\/a>
\nRemoveNull<\/a>
\nReplaceNull<\/a>
\nRemoveError<\/a>
\nReplaceError<\/a>
\nReplaceValues<\/a>
\nCatchLowConfidence<\/a>
\nCatchErrorOrNoSamples<\/a>
\nCatchNoSamples<\/a><\/div>\n<\/div>\n
Mathematics<\/span>
\nSimple Math Expressions
\nAverages
\nMinimums & Maximums
\nSmall & Large
\nCount
\nOther Math
\n<\/a><\/span><\/div>\n
R<\/span>
\nRTimeSeries<\/a> <\/span><\/div>\n<\/div>\n
\n
Shift<\/span>
\nShiftEnd<\/a>
\nShiftNumber<\/a>
\nShiftStart<\/a><\/span><\/div>\n
Time<\/span><\/p>\n
Second
\nMinute
\nHour
\nDay
\nWeekday
\nMonth
\nYear<\/a>
\nAlterTimestamp<\/a>
\nTime<\/a>
\nTimeOf<\/a>
\nRawTimeOf<\/a>
\nTimeOfDay<\/a><\/div>\n<\/div>\n
Time Interval<\/span>
\nTimeEq<\/a>
\nTimeGe<\/a>
\nTimeGt<\/a>
\nTimeLe<\/a>
\nTimeLt<\/a>
\nTimeNe<\/a> <\/span><\/div>\n<\/div>\n
\n
Ungrouped<\/span><\/p>\n
Caller<\/a>
\nConcat<\/a>
\nCurrent<\/a>
\nEval<\/a>
\nEvalExp<\/a>
\nInitial<\/a>
\nSampleFilter<\/a>
\nSampling<\/a>
\nValueAt_Sampled<\/a><\/div>\n<\/div>\n
\u00a0<\/div>\n
\u00a0<\/div>\n<\/div>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

This page shows all the keywords, operators, and functions available to perform calculations in IFS OI Server.<\/p>\n

Read more<\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":9492,"parent":27,"menu_order":79,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[6],"tags":[100],"class_list":["post-3650","page","type-page","status-publish","has-post-thumbnail","hentry","category-landing-page","tag-calculations","Product-srv"],"_links":{"self":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/3650","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/comments?post=3650"}],"version-history":[{"count":10,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/3650\/revisions"}],"predecessor-version":[{"id":67785,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/3650\/revisions\/67785"}],"up":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/27"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media\/9492"}],"wp:attachment":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media?parent=3650"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/categories?post=3650"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/tags?post=3650"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}