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]calculating accrued values
Go
New
Search
Notify
Tools
Reply
  
[SOLVED]calculating accrued values
 Login/Join
 
Gold member
posted
Hi All,

I have a question where I need to calculate the accrued value of an amount field. The value has to be calculated without taking the grouping into consideration.

TABLE FILE CAR
PRINT
CAR.COMP.CAR
CAR.CARREC.MODEL
CAR.BODY.DEALER_COST
CAR.BODY.RETAIL_COST
BY CAR.ORIGIN.COUNTRY
ON TABLE NOTOTAL
END


In the above mentioned code, I need a new filed which calculates the sum of retail_cost at every row and not take the grouping into consideration.
Unfortunately my code has a few levels of grouping which cannot be done with.
I have used the LAST function but unable to achieve what is needed.

Thanks for looking into it.

This message has been edited. Last edited by: sumant,


WebFOCUS 7.7.02Windows
Output Formats: Excel, HTML, PDF
 
Posts: 77 | Registered: February 23, 2011Reply With QuoteReport This Post
Guru
posted Hide Post
TRy this

TABLE FILE CAR
PRINT
CAR.COMP.CAR
CAR.CARREC.MODEL
CAR.BODY.DEALER_COST
CAR.BODY.RETAIL_COST
BY CAR.ORIGIN.COUNTRY
ON TABLE SUB-TOTAL RETAIL_COST
END
-* File car.fex


WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
 
Posts: 398 | Registered: February 04, 2008Reply With QuoteReport This Post
Gold member
posted Hide Post
Hello RSquared,

That was not what I was looking for.
I will try to explain it better.

I need the value of retail_cost summed up at every line with the previous value.
For e.g the first value is 8878, then the second row should be 8878+13491, the third be 8878+13491+17850 and hence forth.
The values should keep on adding till the end without being disturbed by the grouping levels.


WebFOCUS 7.7.02Windows
Output Formats: Excel, HTML, PDF
 
Posts: 77 | Registered: February 23, 2011Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Sumant,
Did you try:
  
TABLE FILE CAR
PRINT 
 CAR.COMP.CAR
 CAR.CARREC.MODEL
 CAR.BODY.DEALER_COST
 CAR.BODY.RETAIL_COST
 COMPUTE ACC_COST/D7=LAST ACC_COST + RETAIL_COST;
BY CAR.ORIGIN.COUNTRY
ON TABLE NOTOTAL
END


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1937 | Location: Tel Aviv, Israel | Registered: March 23, 2006Reply With QuoteReport This Post
Gold member
posted Hide Post
Thanks Danny for the suggestion.

I achieved what I wanted by the following also:

I tried the following and it worked.

TABLE FILE CAR
SUM SALES
COMPUTE CUM_SALES/D12 = CUM_SALES + SALES;
COMPUTE CUM_SALES_2/D12 = LAST CUM_SALES_2 + SALES;
BY CAR.ORIGIN.COUNTRY


WebFOCUS 7.7.02Windows
Output Formats: Excel, HTML, PDF
 
Posts: 77 | Registered: February 23, 2011Reply With QuoteReport This Post
Guru
posted Hide Post
Now we are talking!

Please change the topic´s subject to SOLVED.

This message has been edited. Last edited by: Ricardo Augusto,


WebFOCUS 8.1.05 / APP Studio
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]calculating accrued values

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