0
edits
Changes
no edit summary
The following example calculates the product of the values stored in fields named '''rate''' and '''quantity''', and saves it in a field called '''Total''' with a field ID of 1731330:
'''@l3level3.total@=@level3.rate@*@level3.quantity@'''
''or using the fieldid instead of fieldname''
'''@l3level3.#123100#@=@level3.#123098#@*@level3.#123099#@''' ''Note: Be sure to use '''l3''' before the equal sign, and '''level3''' after.''
* To refer to fields on the associated Level 1 or Level 2 records use ''level1.fieldname''' and '''level2.fieldname''':
'''@l3level3.result@=@level1.hourly rate@*@level2.total quantity@
==Using Template/Type Formulas for Text==