Skip to Content
1
Jul 31, 2007 at 06:27 PM

Data Modeling - Creating a multipling factor for a year

11 Views

We have a need on a report to adjust the result by a percent based on the year. i.e. if the value is 100 and it is in year 2007 we might add 1% making the end result 101. But if the value is 100 and it is in year 2006 we might want to subtract 2% making the end result 98.

My first thought was to create this percent as an attribute on 0CALYEAR, but it is not possible to place attributes on time charateristics. Does anyone have any suggestions for me to consider on how we might model this?

Thanks,

Chris