Days per Month in FCCS Calculation Manager - Leap Years
Summary:
We would like a dynamically calculated member in our ACCOUNT dimension that will compute the number of days in a given PERIOD and aggregate appropriately in concert with the YEARS and VIEW dimensions.
We have a business need to compute a unit per day metric. The member should be able to be retrieved in Smart View or REPORTS
The metric must take into consideration leap years.
Content (required):
When a user selects the following dimension members (PERIOD: Jan, YEARS: FY23, VIEW: Periodic) we want the calculated member to render 31.
When a user selects the following dimension members (PERIOD: Feb, YEARS: FY24, VIEW: Periodic) we want the calculated member to render 29.
Tagged:
0