Skip to content

Instantly share code, notes, and snippets.

@webbyworks

webbyworks/ap-closing-balance-monthly.txt

Last active August 29, 2015 14:06
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save webbyworks/fb58da04f82e4d33f716 to your computer and use it in GitHub Desktop.
Save webbyworks/fb58da04f82e4d33f716 to your computer and use it in GitHub Desktop.
Download ZIP
This calculates the Closing Balance for the end of the month for the Cash Flow Cube Sheet.
Raw
ap-closing-balance-monthly.txt
if ( isBlank( ASSUM.CF.WeekNum ), 0,
if ( ACCT.CF.WeekNum = ASSUM.WksMonth,
ACCT.CF.OBalMonthly[Weeks=Week 1] + ACCT.CF.NetCashMonthly
, 0 )
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment