How to simplify a formula

[renee35]

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

 

[budbeth]

I would think that if you put the formula in the DATA tab query, you could just refer to the field as REVENUE.

 

[reynam]

Add a calculated field to the dataset