Instead of manually entering data, you can use the Spread function to enter calculated values based on the total amount you want to be distributed across the cells in a row. You can, for example, spread 24000 across 12 periods (months) using the distribution rule Even, so the value of each cell in a 12 month period is set to 2000. The default distribution rule is Even, but you can create custom distribution rules to spread the amount differently. You can also use spread based on the comparable data set up in the budget template. For more information, see the Define Comparable data section in Create budget template in Report Designer.
Tip: This method can also be used to spread an amount across a line item detail. See Add line item details.
To spread an amount across a row (main line):