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

Unexpected Dynamic Time Series behaviour with Time Balance Properties

Summary:

Dynamic Time Series numbers shows flow behaviour for member with Weighted Average - Actual_Actual & Weighted Average - Actual_365 TB Property

Content (please ensure you mask any confidential information):

I am trying to display YTD Values for different time balance accounts. Flow and Average Accounts work as expected showing aggregate and average values respectively. However when account has Weighted Average - Actual_Actual or Weighted Average - Actual_365, Dynamic time series YTD/QTD values display aggregating values instead of Weighted daily average, based on the number of days.

Below is SmartView retrieval showing behaviour. I don't think aggregation is expected against accounts tagged as time balance Weighted average. Interestingly Q1, Q2… YearTotal values are as expected for these accounts.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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