Solved

Prices / currency calculation in a view

Posted on 2004-08-09
2
281 Views
Last Modified: 2013-12-18
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 ?

-Ke
0
Comment
Question by:kkiddie
2 Comments
 
LVL 15

Accepted Solution

by:
Bozzie4 earned 200 total points
ID: 11759742
You can, using a string (you'll need to adapt the rounding rules to what applies in Canada) :

price := mypricefield;
tax := price*7/100;
total := @round(price + tax;1/100);
@text( price; "C,2")+ " + " + @text( tax; "C,2") + " = " + @text( total; "C,2")

But you will probably want these values in your documents too, so it's better to do these calculations in fields in your documents !

cheers,

Tom

0
 

Author Comment

by:kkiddie
ID: 11761967
Thanks, Tom. It works.

I should have read more of the @Text help, I guess the answer was there... Still it is helpful for me as a beginning coder to see your approach.

Cheers,

-Kendall
0

Featured Post

ScreenConnect 6.0 Free Trial

Check out the updates in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI that improves session organization and overall user experience. See the enhancements for yourself!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question