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     Manipulate Row Total with Across?
Go
New
Search
Notify
Tools
Reply
  
Manipulate Row Total with Across?
 Login/Join
 
<Jonathan Sutter>
posted
I am working on a report that uses an ACROSS field to produce columns of case counts by each ACROSS value. (The report also uses a number of BY fields but I don't believe these play into my problem.) I need the final column on the right to act like a row total except that there are two columns that need to be excluded from that total.

I have tried the ACROSS-TOTAL with COLUMNS, but this results in those two columns not being included in the report.

I created a DEFINE field that, when summed, would produce the correct total, but I don't want it to appear with each column in the report.

I've tried a multi-verb request to use that DEFINE field separately, but this apparently won't work when you use an ACROSS.

I made a version of the report that created DEFINE fields for each possible value for the field I used in the ACROSS in the other attempts. This worked, but it slows down the report considerably and causes other problems with other features that really need the thing to work with an ACROSS field.

Is there some way to modify a row total in an expression?
Is there a way to make a multiverb request work with ACROSS sorts?
Any ideas??
 
Reply With QuoteReport This Post
Master
posted Hide Post
Jonathan Sutter

If you always have the same # of fields and across' in the report. You might try holding the data with the across in it. This will create new fields for each field in the across. After you hold the report issue a
quote:
? HOLD HOLDFILENAME
Replace HOLDFILENAME with the name of your hold file. This will give you a list of fields in the hold file. Then you can print the fields and compute a your own row total field and print it. Give this a try and post your results. Smiler Good Luck Smiler
 
Posts: 862 | Registered: May 24, 2004Reply With QuoteReport This Post
Guru
posted Hide Post
You can try a technique COMPUTEing a field AFTER the sort statements and using column-notation.

Here's an example:

TABLE FILE EMPDATA
SUM SALARY

BY DEPT
ACROSS DIV

COMPUTE
EAST_TOTAL/D12.2MS = C3 +C4;
AS 'Total - East'
COMPUTE
OTH_TOTAL/D12.2MS = C1 + C2 + C5;
AS 'Total - Other'
END

Just be aware that if you change the field format of the verb objects, on the fly, you end up with 2 internal columns so your column notation has to take into account 2 occurrences of every column.

If that doesn't make sense, let me know and I'll explain.
 
Posts: 346 | Location: Melbourne Australia | Registered: April 15, 2003Reply With QuoteReport This Post
<steegh>
posted
There is a simple way to solve this problem, with one disadvantage.
You can use u multi verb request as follows:

SUM DEFINE_FIELD
BY SORT1
BY SORT2
SUM OTHER_FIELD
BY SORT1
BY SORT2
ACROSS ACROSS_FIELD
END
The only problem is that the total field will be in front of the across fields.

GR.

Robert
 
Reply With QuoteReport This Post
<Jonathan Sutter>
posted
Thanks to all three of you for your suggestions. The multiverb approach won't work for me due to specific layout needs. I tried the COMPUTE after the ACROSS and it didn't recognize the COMPUTE. I haven't tried the HOLD idea yet. Alas, due to an imminent change in duty stations, I will no longer be developing reports with WebFocus so I cannot pursue this one further.
 
Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Manipulate Row Total with Across?

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