Hi,

Just writing a salary report for a client. They wish to have a ongoing running total for base salary and have it totalled as it increases.

As you can see the fields below I have the starting salary. Then the increase then the Base Salary which will be my running total.

My issue is how do I add the increase in the running total. I assume its a formula in the evaluate?

Thanks


Date            Start Sal Increase Base Salary
01/12/2003     62,000      0          62,000
01/12/2003                 0           62,000
31/12/2003                 5,000       67,000
31/12/2004                 1,000       68,000
31/12/2005                 5,000       73,000


Edited by dallasf - 17 Jun 2014 at 7:43pm

It sounds like you are wanting to have a total of all the salary increases added together, in this case 5,000 + 1,000 + 5,000, as opposed to displaying each individual increase.

You'd want to do something like:

numberVar salaryIncrease := salaryIncrease + (salaryBase - salaryStart);

If the data doesn't carry over, use "global numberVar".

To do summary with respect to group you are on the right track by putting it in the header (or footer). The other thing is that you'll need to modify your formula to pay respect to that grouping.

Using your recent formula as an example, I would change it to:

global numberVar salaryIncrease := sum((salaryIncrease + ({@StartingSalary} + {@Increase})), {@GroupName});

Although I am thinking to calculate your salaryIncrease appropriately you'd want to subtract salaryStart from salaryBase for each iteration.

Example assuming salaryStart is updated each iteration to represent the previous salaryBase:

global numberVar salaryIncrease = sum((salaryIncrease + (salaryBase - salaryStart)), {@GroupName});

Or if your salaryStart is not updating each time, and you are just working with the original number, this simpler version might work:

global numberVar salaryIncrease = sum((salaryBase - salaryStart), {@GroupName});


Edited by Erik - 07 Jul 2014 at 2:00pm