Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to simplify a formula

Status
Not open for further replies.

renee35

MIS
Joined
Jan 30, 2007
Messages
199
I have a formula similar to the one below. How can I name this formula so I can use it throughout the report without having to enter the entire formula everytime I need to use it?

CAST(SPTY.REVN_AMT AS DECIMAL(10,2)) as REVENUE--- In this case the column heading is labeled "REVENUE". How can I name this formula so when I need to use it again I will only have to type that one word. For example, the formula name could be "SOLD" and when using it in another place I could type something like this:

SOLD/2...

Thanks for any advise!!

-T

Thanks a bunch!!

-T
 
I would think that if you put the formula in the DATA tab query, you could just refer to the field as REVENUE.
 
Add a calculated field to the dataset
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top