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