Focal Point
[SOLVED] Percent change on subtotal

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5537072276

August 20, 2014, 11:50 AM
Teri
[SOLVED] Percent change on subtotal
I have a procedure where I have two calculated fields summing sales dollars for 2013 and 2014 by customer. I have those two fields on my report and have calculated a percent change year over year by customer. I have a subtotal on customer region that totals the sales dollars by region for groups of customers. How can I calculate the percent change year over year on my region subtotal? It is summing the percent changes for the region on the subtotal now. Looks like this:

2013 2014 % Change
Customer A 200 250 25%
Customer B 500 400 -20%
Subtotal 700 650 -5% should be -7.1%

It is summing the % Change percentages to get the -5%. How can I calculate the percent change for the Subtotal?

This message has been edited. Last edited by: <Kathryn Henning>,


WebFocus 8
August 20, 2014, 12:49 PM
jfr99
Hi Teri,

Try using: ON REGION SUMMARIZE

Instead of: ON REGION SUBTOTAL

Let me know if that works.


WebFocus 8.201M, Windows, App Studio
August 21, 2014, 08:57 AM
Teri
Yes that worked. Thank you!


WebFocus 8