V.10
XML data using ADO.NET (xml) driver
Account Asset Table joined to SubAccounts Table in a 1 to many relationship.
Two columns in my report look like this:
Net Equity % of Net Equity
Group 1 10,000 Net Equity/Total Net Equity
Details 5,000 Net Equity/Total Net Equity
etc.
I am using Running totals for all of the number fields which actually have 3 layers of grouping, and they are all working correctly. My problem is in the % of Net Equity column because Total Net Equity doesn't seem to be available (I think). I have to use Running Totals (I think) because the 1 to many data structure causes summing problems when I use the Sum function.
Lastly, I tried using the EvaluateAfter() command in my percent formula to tell to evaluate after the Running Total but that didn't work.
Is there a workaround for this problem?
Many thanks,
ebutter
XML data using ADO.NET (xml) driver
Account Asset Table joined to SubAccounts Table in a 1 to many relationship.
Two columns in my report look like this:
Net Equity % of Net Equity
Group 1 10,000 Net Equity/Total Net Equity
Details 5,000 Net Equity/Total Net Equity
etc.
I am using Running totals for all of the number fields which actually have 3 layers of grouping, and they are all working correctly. My problem is in the % of Net Equity column because Total Net Equity doesn't seem to be available (I think). I have to use Running Totals (I think) because the 1 to many data structure causes summing problems when I use the Sum function.
Lastly, I tried using the EvaluateAfter() command in my percent formula to tell to evaluate after the Running Total but that didn't work.
Is there a workaround for this problem?
Many thanks,
ebutter