Sscalculation

Revision as of 16:53, 20 August 2009 by Cameron (talk | contribs)

Revision as of 16:53, 20 August 2009 by Cameron (talk | contribs)

Sscalculation is a variable syntax for:


This works similar to sslogic but will do calculations based on the formula you provide. It works as follows:


<!--@sscalculation(@field@*0.05)-->

This will return the computed value of @field@*0.05 and replaces the sscalculation tag.

This way you can do calculations right on the web page views without having to use javascript which solves the problem on PDF and javascript.

This method uses MySQL syntax, so you can do any MySQL functions like concat(...), format(...), round(...), etc.

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:

<!--@sscalculation( [#(?object=transaction;)$add this$+#]0)-->


  • Important: There must 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).