Prices / currency calculation in a view
Posted on 2004-08-09
I would like to do the following in a view formula: have it display a price (which is entered on the document by the user), calculate the tax (7% Canadian GST), and add it to the price for a total.
i.e. to have the view column formulate something like the following: $1,295.00 + $90.65 = $1,385.65 (if the "price" field contains $1,295.00)
The problem I am having is that the view column converts the currency amount to a plain number (i.e. $1,295.00 to 1295), but when I configure the column for currency it will not accept the any text strings (" + ", " = ", etc.).
Is there any way to get the view column to calculate and display like this -- $1,295.00 + $90.65 = $1,385.65 ?