Date1 - Date2 excluding holidays

[Lesio]

Any idea to modify existing metrics calculating days between two given dates: Facts are defined as: Date_n+1 - Date_n and metrics as sum(Date_n+1 - Date_n). These calculations should exclude company holidays.

This is MicroStrategy 7.2.3 platform. The database platform is DB2 and the fact table stores all dates.

Table

Attr1
Attr2
Attr3
...
Date_n
Date_n+1
Date_n+2
...
Amt_n
Amt_n+1
Amt_n+2

 

[nlim]

one way is to create a metric called "# holidays" and filter it to the specific dates.

Then just do a compound metric.