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     [SOLVED] Computing # of Days Between Certain Transaction Types

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Computing # of Days Between Certain Transaction Types
 Login/Join
 
Gavin B
Member
posted
Calling all InfoAssist experts! I am seeking your recommendations on approaches for how to report on the # of days between a pair of unique transactions.

Each transaction has a unique transaction type. Lets call them Reserve_Change and Final_Payment.

Imagine a transaction ledger filled with a variety of transactions and transaction types of which these are a subset.

When the Final_Payment is made and the case is closed, I need to look back to when the last Reserve_Change was made and count the # of days between those two dates.

InfoAssist is the tool I have available and I am a business user, so a list of program code will do me no good here.

Thanks,
Gavin

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


WebFOCUS 8.10.5
Windows 10, HTML
 
Posts: 13 | Registered: April 13, 2016Report This Post
WF_IL
Platinum Member
posted Hide Post
Hi

I would recommend 2 options:

1. The easiest for you as a business user is to request from your WF administrator who takes care of cluster master files to "bring" to the Final_Payment record its corresponding last reserve_change. He can create a join on the cluster master level to SQL Script which will calculate for each transactionn its last reserve change date. Then when you ahve it on the same record level it will an easy calculationn between dates

2. Second option which is available in the full InfoAssist is to create a multi step request with HOLD files and joins in order to bring these 2 dates to the same record level.


Yours,
Eran
SRL Products

http://www.srl.co.il

 
Posts: 97 | Location: Tel Aviv, Israel | Registered: November 20, 2005Report This Post
Tamra
Guru
posted Hide Post
Gavin,

The use of code is very useful within the setting of new temporary fields (DEFINE or COMPUTE) for calculations in the form of IF... THEN ... ELSE. You can check the values of the fields and then perform a calculation such as the difference between dates. The use of the InfoAssist functions are very handy.

InfoAssist does provide the buttons with these commands embedded for your use.

As suggested a HOLD file (temporary file) is useful to get prepare the data in a way that can then be used with a define or compute field.


You can search the WebFOCUS or InfoAssist forum for ideas on IF ... THEN ... ELSE logic.

Thank your for participating in the Focal Point Forum,
Tamra Colangelo
Focal Point Moderator
Information Builders


WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
 
Posts: 487 | Location: Toronto | Registered: June 23, 2009Report 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     [SOLVED] Computing # of Days Between Certain Transaction Types

Copyright © 1996-2020 Information Builders