8,849
edits
Changes
no edit summary
* To find the average of all values (Custom Field ID 1755555) on a particular Level 2 Type (typeid=54321), excluding a particular status ([[statusid]] is not 10001), rounded to the nearest whole number:
<!--@sscalculation(format( ( [#(?object=activity;criteria=typeid='54321' and status.statusid not in ('10001')) $1755555$ + #] 0 )/@level2.count(*):typeid='54321' and status.statusid not in ('10001')@,0))-->
==Using sscalculation to Change Date Formats of Data in Custom Fields==
* To parse out date/time information from a custom field and display it in a different format, you can use the following syntax:
<pre><!--@sscalculation(date_format("@parent.fieldname@","%M %d, %Y"))--></pre>
* This is not necessary if the custom field being referenced is on the same level as the field referencing it. In this case, you can use the syntax outlined on the [[Web_Page_View_Field_Variables#Custom_Fields_Date.2FTime|Web Page View Field Variables]] page
[[Category:Variables]]