You want to calculate value between fields in WCE, we have a variety of examples, based upon previous requests, an example of the math behind a customised newsale.html is included below.
- value="[calculation]" - where the calculation can be defined numerically. For example:
You can use other WiredContact tags, like the <#adminhelp file=FieldTag.html label="<#Field...>"> tag or <#adminhelp file=ParamsTag.html label="<#Params...>"> tag to define your calculation. For example:
<#calculate value="<#date format=number> - <#field field=createtime format=number>" mask=#>
will show how many days since the record was created, with no decimals.
- Mask=["#,##0.0'] - specify the mask to use to display the value. Alternately, if the results should be displayed as a specific format, use "date", "datetime", "currency".
- ZeroMask=["0"] - specify the mask to use if the results are zero, and the format to use when zero is different.
- Show="[<#adminhelp file=BooleanPhrase.html label="boolean phrase">]" - if the boolean phrase is true, the <#calculate...> tags results are shown. Use this parameter to suppress/hide the results under specific circumstances.
If you cannot see what you need or require support please sumbit a ticket to email@example.com