Passer au contenu principal


Workday Adaptive Planning Knowledge Center

Create time rollups for beginning cash in a Cash Flow Statement

This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release.


How do I create proper Time Rollups for Beginning Cash in my Cash Flow Statement?


1.  Create a new Assumption or Custom Account called Beginning Cash Weight Acct and add this to the Assumptions sheet or another plan-independent sheet.

2. In the Assumptions sheet or Formulas Tab (if you created a Custom account in step 1), create a formula that populates 1,000,000,000,000 for January and 1 for April, July, and October.  The formula will look something like this:

if(month(this)=1, 1000000000000, if(month(this)=4,1, if(month(this)=7,1, if(month(this)=10,1,0))))

3.      In the Beginning Cash account, set the Time rollup to Weighted average of rolled-up values and weight on the Assumption we created in the step above.


  • Cet article vous a été utile ?