PDA

Click to See Complete Forum and Search --> : [RESOLVED] formula balance


j0shua
Feb 12th, 2009, 12:25 AM
hi there!, hope somebody can help me, i want to get the running balance of my yearly budget like this

Budget Full Year: 2,284,500.00
total expenses on january: 160,000.00
BUDGET BALANCE: 2,124,500.00

total expenses on february 100,000.00
BUDGET BALANCE: 2,024,500.00

i was trying a formula code like this:

numbervar budget := budget - totalexpenses;
i placed it in the group section,

but it wont work, anybody there who knows this? thank you.

j0shua
Feb 12th, 2009, 12:33 AM
i modified my code and tried this:

numbervar budget;
budget :={usp_rpt_BudgetMonitoringReport;1.BUDGET AMOUNT};
budget := budget - {#RTotal0};

it wont work either, the budget keeps on reseting to its original amount

jggtz
Feb 12th, 2009, 07:50 PM
Try terminating the formula with the variable name after a semicolon, as

numbervar budget := budget - totalexpenses; budget;