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.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Using Define as Title - InfoAssist

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Using Define as Title - InfoAssist
 Login/Join
 
Andrea L
Member
posted
I have a report where I calculate a prior year and then a current year sold amount. I want to have the titles of these measures equate to another define I created. What is the right syntax to use in the title field to make that work?

YTD Sales: if current_year = 0 then sales_amount else 0

LY Sales: if current_year = 1 then sales_amount else 0

these two get my values.....I then created:

ytd_name: if current_year = 0 then accounting_year

ly_name: if current_year = 0 then accounting_year

These two get me the year name (as 2015, 2014).

How can I put that in the title? I know if I do &with the field name it prompts me to enter a value which then appears, but I don't want that. I just want to have the value appear based on the define.

anyone??

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


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 5 | Registered: January 13, 2014Report This Post
Luiz De Assis
Platinum Member
posted Hide Post
Andrea,

Do you have access to the Text Editor in InfoAssist? These code creates dynamic titles, and will change as the year changes; however, you won't be able to open the report using the GUI. Thanks

Luiz

Column Current Year:
-SET &CurYR = (DATECVT(EDIT(&YYMD,'9999'),'A4', 'I4') ) ;

Column Last Year:
-SET &LastYR = (DATECVT(EDIT(&YYMD,'9999'),'A4', 'I4') -1) ;
 
Posts: 117 | Location: Denver | Registered: July 27, 2005Report This Post
Andrea L
Member
posted Hide Post
Thanks - I'll try that.


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 5 | Registered: January 13, 2014Report This Post
Andrea L
Member
posted Hide Post
Any other suggestions? unfortunately, when it goes to text, I can't hand it over to a user to maintain. They don't know how to edit via text.


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 5 | Registered: January 13, 2014Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Using Define as Title - InfoAssist

Copyright © 1996-2020 Information Builders