Summary Reports
I'm trying to create a Summary report where I need two formulas. See below:
The four fields are Pool Dollars, PWO Pool Dollars, Non-Pool Dollars, and PWO Non-Pool Dollars
On this report I'd like...
Forum Discussion
In the end I need to end up with two columns:
Total Pool Dollars Total Non-Pool Dollars
I created a formula for each, but in the Summarize Data section, it only allows you to pick one field. How do I get both fields displayed?
------------------------------
Terri Wells
------------------------------
Total Pool Dollars Total Non-Pool Dollars
I created a formula for each, but in the Summarize Data section, it only allows you to pick one field. How do I get both fields displayed?
------------------------------
Terri Wells
------------------------------
No problem. You just need to click the plus sign on the right hand side in the Summarize Data section. Click the image below to expand it.
- I'm now able to get both fields to display, but there must be something wrong with my formulas. It's only showing the value from the first field in each formula. The two formula are below:
[Pool Dollars] + [PWO Pool Dollars] The total I'm expecting to see is $119,000.00 which is the total of the two field, but the total I'm getting is $24,000.00, which is the total of the first field.
[Non-Pool Dollars]+[PWO Non-Pool Dollars] I'm getting the same results, only calculating the first field.
Any help would be appreciated.
------------------------------
Terri Wells
------------------------------- Are your [Pool Dollars], [PWO Pool Dollars], [Non-Pool Dollars], and [PWO Non-Pool Dollars] fields all simple numeric fields or are they formula numeric fields?
------------------------------
Adam Keever
------------------------------The fields are currency type field, with 2 decimal places. They are not formula numeric fields.
------Original Message------
Are your [Pool Dollars], [PWO Pool Dollars], [Non-Pool Dollars], and [PWO Non-Pool Dollars] fields all simple numeric fields or are they formula numeric fields?
------------------------------
Adam Keever
------------------------------
