You now have the option of using the currency field type within your online database and having it automatically format the data in USD format. You can choose the currency field type from within the Full Database Editor or the Database QuickStart method.
If you want to edit an existing numeric field within your online database and convert it to a currency field, you will use the full database editor to edit your database. Edit the field options by clicking on the field hyperlink. You will then see a radio button list of where to select Currency.
click on image to enlarge
If you are creating a database from scratch using the Database QuickStart method, add the field name and select Currency as your field type.
click on image to enlarge
Once your field is updated and saved, you will see the formatting display in your database.
click on image to enlarge
Now that you can add Grouping to Your Online Database Views and can add Subtotals, Grand Totals, and Other Aggregate Functions in Your Online Database Views, you can create views and totals around your currency fields. In the example below we have the data grouped by Client and have included subtotals.
click on image to enlarge
As always, please feel free to contact us with any questions! We are always more than happy to speak with you. If you don't have a GroveSite and want to get started, get started for free here.


Magento proffers a set of functional application and features that caters the basic requirements of an online business. Beyond the fundamental functionality, Magento can also be augmented, through either custom codes or add-ons supplied by the related communities.
Posted by: ecommerce website hosting | May 01, 2012 at 07:36 AM
No one doubts that thousands and thousands of dollars are being made every single day by individuals and home workers with online stores. There is lots of information "out there" for people who would like to own their own store-too much information, in most cases! Here are a few things that you need to know if you are interested in setting up your own online store.
Posted by: best ecommerce sites | May 10, 2012 at 06:45 AM
So wonderfully written blog,which includes much information we are lookingfor.Now you make it easy for me to understand and implement the concept.We will recommend this to friends.
Posted by: Ray Ban Wayfarer | June 03, 2012 at 07:41 AM
I know that everybody must say the same thing, but I just think that you put it in a way that everyone can understand. I also love the images you put in here.
Posted by: NBA Jerseys Store | June 03, 2012 at 07:42 AM