0
edits
Changes
no edit summary
This method uses MySQL syntax, so you can do any MySQL functions like concat(...), format(...), round(...), etc.<br>
==Using sscalculation in a list==
To obtain a Sum (for example) of the values in a [[Custom Field]] for all transactions associated with a Company/Contact using [[sscalculation]]:
<pre>
<!--@sscalculation( [#(?object=transaction;)$add this$+#]0)-->
</pre>
* '''Important:''' There <u>must</u> be a space prior to the opening square bracket.
* Also: don't forget the zero at the end of the statement. For example, if there are transactions with values of 10, 15 and 20 the statement between the square brackets would be translated as follows:
::''[#(?object=transaction;)$add this$+#]'' becomes ''10+15+20+''
so the 0 at the end ensures that the statement evaluated doesn't end with a plus sign (which will fail).
[[Category:Variables]]