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 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.