Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Spread values evenly across Period dimension using @xwrite — Cloud Customer Connect
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

Spread values evenly across Period dimension using @xwrite

Accepted answer
11
Views
2
Comments

Newbie Here....

Is it possible to spread values evenly across the Period Dimension (Jan:Dec) using grid spread like what is available in forms?

For example, I have Labor data sitting at Period BegBalance and I want to copy this into the Finance Cube's Period Full Year and have the system spread back 1/12 of the total copied amount to each child (Jan, Feb, Mar, etc.)

We currently do not budget to Full Year in the Labor cube, but may have to pivot to Full Year if this is not possible.

Example:

Thanks in advance!

Version (include the version you are using, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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