Skip to Content
0
Former Member
Oct 18, 2005 at 10:14 AM

Calculated Key Figures

55 Views

I am trying to write the formulas for 2 calculated key figures which are based on dates. In the first one my value is to be calculated as follows

Calculated Key Figure 1:

The date has to be greater than 01.01.2002 and it has to be less than the report date – one year

Calculated Key Figure 2:

An existing field (Date_Field1) is less than another date field [(Date_Field2) + 12 months]

Could anyone advise. Thanks