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

How to prevent dates from adding up (sum total)?

Hello,

In Planning and Budgeting Cloud, I have a Dimension called "Date" that I use to design a Layout in Form and Ad Hoc Grid Management. When viewing the Form as a grid, the dates would "add up" and have a "sum total" as seen in the attached "Dates Sum Total.jpg" file.

In researching, I found a response saying to set the aggregation to "Never" in the Dimension Member Properties. This particular dimension member has a Plan Type in the ASO cube and does not have the option to set to "Never" in the drop-down (please refer to the Plan Type Option.jpg file attachment).

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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