Stonefield Query
 
Stonefield Site Map
Stonefield Support

  Overview
  Submit Support Ticket
  Forums
  Online Help Files
  Services
  Pre-Sales Support
Online Webinars
Video Demonstrations
Feature Requests
  Software Maintenance
  Support Testimonials
  FAQ's
Quick Links
Buy Now!
Download Free Trial
Watch a Video
Contact Us

 
 You are here: Support * Support Forums   Search

 Stonefield Query Support Forum

Welcome to the Stonefield Query Support Forum. Please note that in order to participate in the support forums, registration at our site is required. If you are already a member of our site, please sign-in.

 
Forums > Stonefield Query Solutions > GoldMine Reporting - Support
Subject: Create a formula Field

You are not authorized to post a reply.   

Author Messages
Iain Wicks
Posts:5
03/23/2008 1:42 AM Alert 

Can i create a formula field?
In GoldMIne I havea field with a multiple pick list. So the value could be "A, B, C" . I want to create a formula field something like if field contains "A" then "Hat", else if fields contains "B" then "Gloves", else if field contains "C" then "Scarf" else "".

Can't see where to do that.
dhennig
Posts:100
03/23/2008 9:52 AM Alert 
Hi Iain.

There are two ways you can create your own calculations: in the Advanced Report Designer or in the data dictionary. See the Advanced Report Designer and Customizing the Stonefield Query Data Dictionary topics in the help file for details.

In your specific example, you will likely want to use the built-in ICASE function (discussed in the Function Reference topic in the help file), using something like this:

ICASE(MyTable.MyField = "A", "Hat", MyTable.MyField = "B", "Gloves", MyTable.MyField = "C", "Scarf", "")

Doug
Iain Wicks
Posts:5
03/23/2008 2:25 PM Alert 

Thanks
You are not authorized to post a reply.
Forums > Stonefield Query Solutions > GoldMine Reporting - Support > Create a formula Field


ActiveForums 3.6

 
 
   Privacy Statement  |  Terms Of Use
© 1996-2008 Stonefield Software Inc. All rights reserved.