Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
Total and subtotal
 Login/Join
 
<eab>
posted
Hello, everyone!

I neeed to create summary report for students by 4 regions. 3 regions has to be by city and student and last one only summary line. Also I asked to do subtotals by region and total for first 3 region and total for all of them.

SUM
STUDENT
compute fields
BY REGION NOPRINT RECOMPUTE MULTILINES AS 'Total for '
BY CITY
BY STDNT_NUM

What I have to code to supress students lines for region EQ '04' and get total for regions '01' '02' '03'?
 
Report This Post
<Pietro De Santis>
posted
Something like:



SUM
STUDENT
compute fields
BY REGION NOPRINT
BY CITY
BY STDNT_NUM
ON REGION RECOMPUTE MULTILINES AS 'Total for '
WHEN REGION NE '04'
END

This message has been edited. Last edited by: <Mabel>,
 
Report This Post
<eab>
posted
Yes, I tried this but I have no total for Region 04, and it not helps with total for first 3 regions
 
Report This Post
<WFUser>
posted
If I understand you correctly, you want to sort by region and city only if region in not 4 and you want just a total for region 4. Would something like this work?

DEFINE FILE filename
SORTFLD/An = IF REGION NE 4 THEN REGION | CITY ELSE REGION;
END
TABLE FILE filename
SUM fields
BY SORTFLD
SUBTOTAL
 
Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders