Changes

Calculating Information between Levels

721 bytes added, 21:56, 9 April 2009
no edit summary
Note: Currently the system doesn't support summing from level 3 to level 1 using a custom field id. The summing would only work with Amount and Duration field.
 
 
==Using a Level 3 Type Formula==
 
You can use the Level 3 Type Formula field on the Level 3 Type page in a similar manner as for Level 2.
* The advantage of using a Level 3 Type Formula instead of a Calculated field is that the calculations are done server side, rather than by the browser.
</br> Thus if you are doing a calculation on a value that needs to be populate or calculated on the same Level 3 item it avoids you having to save twice in order to get the final result.
 
The following example calculates the product of rate times quantity, and saves it in a field called Total with a field ID of 1731330:
'''@l3.#1731330#@=@level3.rate@*@level3.quantity@'''
 
''Note: Be sure to use syntax exactly as above.''
 
[[Category:Universal Tracking Application]][[Category:Applications]]
0
edits