Difference between revisions of "Transaction Formula"

From SmartWiki
Jump to: navigation, search
(Created page with '@level2.Allocations@="@trans2.sum(#12345#)@" In this example, '''level2.Allocations''' is the custom field we are storing the sum in. The sum is of the value in custom field 123…')
 
Line 1: Line 1:
@level2.Allocations@="@trans2.sum(#12345#)@"
+
=Examples=
 +
==Transaction==
 +
@trans.#123456#@ = "@trans.#1230000#@";
 +
 
 +
In the above example we are updating transaction field @#123456#@ with a new value from #1230000#@ using transaction formula itself.
 +
 
 +
==Level 2==
 +
 
 +
@level2.Allocations@="@trans2.sum(#12345#)@";
  
 
In this example, '''level2.Allocations''' is the custom field we are storing the sum in.
 
In this example, '''level2.Allocations''' is the custom field we are storing the sum in.

Revision as of 03:58, 12 September 2013

Examples

Transaction

@trans.#123456#@ = "@trans.#1230000#@";

In the above example we are updating transaction field @#123456#@ with a new value from #1230000#@ using transaction formula itself.

Level 2

@level2.Allocations@="@trans2.sum(#12345#)@";

In this example, level2.Allocations is the custom field we are storing the sum in. The sum is of the value in custom field 12345 of all transactions on the Level 2.