Changes

==General Description==Executes an expression to calculate a value and store the result. Additional information can be found in the [[SmartSimple]] wiki. =='''Field Options'''==

* '''Expression''' – defines : Defines the expression to be executed.(additional details on Expression found in section below){{LabelAboveField}}{{ToolTip}}{{HideFieldForNewRecord}}{{SmartFieldView}}

==Expression Field Details=='''Expression''': Defines the expression to be executed All values are treated as strings. For arithmetic operations, PARSEINT and PARSEFLOAT functions are used to convert the string value to a numeric value.

''ParseFloatssParseNum([Total Monthly Cost]) + ParseFloatssParseNum([Total Cost Ex]) + ParseFloatssParseNum([Hardware Rental]) + ParseFloatssParseNum([Email]) + ParseFloatssParseNum([Other])''

<pre>If you are using this field in a '''"Dynamic Control Field''' " address the fields by thier their field ids with the following syntax:

Example: ''PARSEFLOATssParseNum(frm.cf_1254625.value)*0.44'' </pre> {{OptionsTab}}{{Searchable}}{{TrackChanges}}{{HideField}}{{DisableFromGlobalSearch}} =='''Field Validation'''Formatting== {{FieldFormattingOptions}} ==Value Storage=={{ValueStoresTo}}

==Notes==* Calculated field formulas are executed You can in general use either the same order that name of the field within square brackets, or frm.cf_''customfieldid''.value to refer to the calculated fields are displayed on values for the pagecalculations. * You In both cases is that the field must not place fields be visible on the page (or a [[Hidden Value]] custom field that perform summary calculations based is on other calculated fields ABOVE the subordinate calculationspage). * If the fields are ordered A [[Combo Box]] custom field can be used in this manner, saving mathematical as long as the page will stored value is numeric. The displayed value does not update the summary calculation, as summary formula will have to be numeric* [[Check Boxes]] cannot normally be executed BEFORE the subordinate calculations are performedused in Calculated Value fields.(They can be accommodated with sufficient knowledge of JavaScript)

===Arithmetic Operators===** To round a calculation to 2 decimal places use the following syntax:*** '''Math.round(('''''expression''''')*100)/100''''''Note:''' To round to a different decimal place just change '''*100)/100''' part as per requirement. Example:To round to 3 decimal places, you would use '''Math.round(('''''expression''''')*1000)/1000'''

[[Image*** For no decimal places:CS08**** '''Math.pnground('''''expression''''')'''where ''expression'' is the calculation to be rounded off, such as PARSEINT([variable 1])/PARSEINT([variable 2])

'''calage([date of birth])''' - Calculates the number of full years between the current date and the date included in the function.'''calage([Image:CS085date of birth],1)''' - Calculates the number of years and months between the current date and the date included in the function as a floating point.png]'''calage([date of birth],2)''' - Calculates the number of years and months between the current date and the date included in the function as the string "X years and Y months".

 **** ''timediff(frm.ostartdate.value,frm.oenddate.value,frm.ostarthour.value,frm.ostartminute.value,frm.oendhour.value,frm.oendminute.value)''

 **** ''timediff(frm.startdate.value,frm.enddate.value,frm.starthour.value,frm.startminute.value,frm.endhour.value,frm.endminute.value)''(note: the starttime and endtime '''Standard Fields''' are actually stored as part of the startdate and enddate fields, which is why they are used here)

**** [[Image''fieldname''].lengthTo show the number of words in a text field, use:CS086.png]]

**** [''fieldname''].split(" ").length==See Also==**** [[How Calculated Custom Fields Work]]**** [[ssParseNum]]**** [[Template / Type Formula]]**** [[:Category:Custom FieldsJavaScript]]**** [[Variable List]]**** [[The Musings of Chin - Correct Variable Processor Use]]**** Disambiguation: [[Calculated Field|Calculated Field in Reporting]]{{CustomFieldPageFooter}}