View source for Calculate GST Function

{{JavaScript Syntax}}
You can automatically determine if GST should be calculated on an item and calculate the GST by using the following technique:
 
This example assumes you are adding this functionality to a [[UTA]] level and three existing [[Custom Fields|custom fields]]:
*'''total''' - a text box to store the amount and 
*'''GST''' - a select one combo box to indicate if the item should include '''GST'''.
 
1. Create an additional [[Custom Fields|custom field]] - '''Calculate GST''' as '''Special - Browser Script''' type field.

2. Add the following expression to that field.

'''function calculategst(amount,gst) {if (gst=='Yes') return parseFloat(amount*0.06).toFixed(2); else return parseFloat(0).toFixed(2);}'''

This function - '''calculategst''' can be called from any field, but the Calculate GST field itself will not be displayed.
 
3. Create a calculated field to store the calculated value.

4. Add the following expression to that field.

'''calculategst([Total],[GST])'''

This expression is called the '''calculategst''' function and passes the total and the gst values.  If GST is applicable, then the value is calculated and returned (to 2 places of decimal) else 0.00 is returned.

[[Category:System Management]][[Category:JavaScript]]