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

Allocation Rule Location Divided by Total

I need to build a formula that takes each location's total amount for a certain STAT account and divides it by that account's sum total of all locations. A formulaic illustration would be something along the lines of

STAT Location/Total STAT in Ledger

The allocation should generate a journal line for each location. Has anyone build something like this where Level0 Descendants are divided by a All parent to generate individual lines? If so, could you please share your results.

This is what I've got so far

"S1100"→STAT = "All Location Values"→"S1100"→"Ending Balance"→"PTD"→"STAT"

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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