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
It sounds like a report formula would meet your requirements.
Create report formulas, probably type Numeric-Currency I would imagine, but might need to be just numeric. The formula would contain this:
Formula Name: Total Non-Pool Dollars
Formula: [Non-Pool Dollars]+[PWO Non-Pool Dollars]
Then in the summarize data section find your newly created field, it will be at the bottom of the list, and summarize it however you want. Rinse and repeat for your other fields. Does this solve your issue?
If you see a need to use those fields again in other reports then making these into actual fields on the table would make sense. Then you would use them in the same way in multiple reports.
Create report formulas, probably type Numeric-Currency I would imagine, but might need to be just numeric. The formula would contain this:
Formula Name: Total Non-Pool Dollars
Formula: [Non-Pool Dollars]+[PWO Non-Pool Dollars]
Then in the summarize data section find your newly created field, it will be at the bottom of the list, and summarize it however you want. Rinse and repeat for your other fields. Does this solve your issue?
If you see a need to use those fields again in other reports then making these into actual fields on the table would make sense. Then you would use them in the same way in multiple reports.
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
------------------------------