Difference between revisions of "Transaction Formula"
From SmartWiki
(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 04: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.
