You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Days per Month in FCCS Calculation Manager - Leap Years

Accepted answer
22
Views
13
Comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!