Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Percent change on subtotal
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Percent change on subtotal
 Login/Join
 
Member
posted
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
 
Posts: 17 | Registered: May 03, 2013Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Hi Teri,

Try using: ON REGION SUMMARIZE

Instead of: ON REGION SUBTOTAL

Let me know if that works.


WebFocus 8.201M, Windows, App Studio
 
Posts: 221 | Location: Lincoln Nebraska | Registered: August 12, 2008Reply With QuoteReport This Post
Member
posted Hide Post
Yes that worked. Thank you!


WebFocus 8
 
Posts: 17 | Registered: May 03, 2013Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Percent change on subtotal

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.