Hi I'm having a problem with the sum of values for the details section in the group footer section.
I have 2 tables one is member information(tblmemberfinance) the other is where registration information is kept (tblartransitem). The tblartransitem table has a Foreign Key for the member info.
I'm displaying all the registrations for members for a certain date range (my parameters grouped by member.
The fields that are displayed are member name, class
registered, price, dates, balance member owes.
I need to display a value in the Group Footer Section by member what the balance is based of an equation.
Psuedocode below ---
If the currentbalance is >= sum(all the enrolled classes prices/2) then display sum(all the class prices/2)
otherwise
display currentbalance.
Here is the formula that i'm using but it isnt working.
@balanceDue
if {tblmemberfinance.balancecurrent} >= (Sum ({tblartransitem.price}))/(2)
then Sum ({tblartransitem.price})
else
{tblmemberfinance.balancecurrent}
The value that is output for my field is the total of all the classes for all the members that are displayed / 2
instead of a per member basis in the group foother section.
Thanks in advance!
I have 2 tables one is member information(tblmemberfinance) the other is where registration information is kept (tblartransitem). The tblartransitem table has a Foreign Key for the member info.
I'm displaying all the registrations for members for a certain date range (my parameters grouped by member.
The fields that are displayed are member name, class
registered, price, dates, balance member owes.
I need to display a value in the Group Footer Section by member what the balance is based of an equation.
Psuedocode below ---
If the currentbalance is >= sum(all the enrolled classes prices/2) then display sum(all the class prices/2)
otherwise
display currentbalance.
Here is the formula that i'm using but it isnt working.
@balanceDue
if {tblmemberfinance.balancecurrent} >= (Sum ({tblartransitem.price}))/(2)
then Sum ({tblartransitem.price})
else
{tblmemberfinance.balancecurrent}
The value that is output for my field is the total of all the classes for all the members that are displayed / 2
instead of a per member basis in the group foother section.
Thanks in advance!