Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
Solved

# Calculating running balance in a portal

Posted on 2011-02-21
Medium Priority
1,100 Views
I have the following fields
Start Date
End Date
Days absent=EndDate-StartDate
DaysLeaveDue=30 (Fixed value)
BalanceLeaveDue: DaysAbsent-DaysLeaveDue
These fields are placed in a portal in a relatted table and each time leave is taken the entires are made as a LineItem within the portal.
The problem is how to get the BalanceLeave Due calculation to show a running total of leave due for each LineItem.In Other words I want it to read the BalanceLeaveDue of the last entry:
Just in case I am not making myself clear here is an example:

DaysAbsent=3 days (LineItem 1) therefore BalanceLeaveDue results 27 Days
DaysAbsent=2 days(LineItem2)    "                                    "             25 Days (I am not getting this result,instead I am getting 27Days)
0
Question by:Krisraychris
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 15

Expert Comment

ID: 34941553
I think you are not adding DaysAbsent like in your example LineItem1 is 3 days and Lineitem2 is 2 days that is total 5days and when you calculate Days absent You should get 5days
0

LVL 9

Accepted Solution

jvaldes earned 2000 total points
ID: 34941689
You should put the header information such as the LeaveDue days in a Header table and then the line item list in a Detail Table. Relate them by employee number such that the details related to the current header record shows in the portal. Now in the Detail table create a summary field for the DaysAbsent that summarized the DaysAbsent called sumDaysAbsent

Put that field outside the portal area in the area of the Layout that is derived from the header file. That should now contain the total of all days taken. Now add another field on the header table and  layout called BalanceLeaveDue Make this a calculated field that equals LeaveDue-sumDaysAbsent. Now put that on the header layout and it should do what you are asking for
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
###### Suggested Courses
Course of the Month11 days, 15 hours left to enroll