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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you have any questions or need access: Contact myibi@ibi.com


Connect to myibi

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] FORECAST
 Login/Join
 
Member
posted
I am trying FORECAST for the first time. It works fine when my only by field is numeric or a date but when I add my division code (aplha) as the first BY field I get a formatting error. And yes I realize FORECAST needs the last BY field to be numeric or a date. But why does it care if the first one of two is alpha?

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


DEV: WebFOCUS 7.7.02 OS: DB2, Universe
OUTPUT : Html, Excel, PDF, Html(active)
 
Posts: 13 | Location: Kentucky, USA | Registered: August 16, 2007Report This Post
Expert
posted Hide Post
What version are you on ?

The examples in the documentation have a first sort of alpha.

Does it work or fail ?

Calculating Trends and Predicting Values With FORECAST


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6353 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Member
posted Hide Post
I'm on 767. And yes, I saw the help text which made me think it should work but it doesn't. I've tried a combination of things and still no luck. Any help would be greatly appreciated


DEV: WebFOCUS 7.7.02 OS: DB2, Universe
OUTPUT : Html, Excel, PDF, Html(active)
 
Posts: 13 | Location: Kentucky, USA | Registered: August 16, 2007Report This Post
Expert
posted Hide Post
The sample in the documentation works for me on 7.1.6, 7.6.6 and 7.6.9.

Can you repro on one of the samples files, adn post the code ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6353 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Member
posted Hide Post
I will try. In the mean time can I see the code the exapmle produced. It doesn't show that in the example nad maybe that will give me a clue as to where I'm off.


DEV: WebFOCUS 7.7.02 OS: DB2, Universe
OUTPUT : Html, Excel, PDF, Html(active)
 
Posts: 13 | Location: Kentucky, USA | Registered: August 16, 2007Report This Post
Member
posted Hide Post
This is closed. Thanks


DEV: WebFOCUS 7.7.02 OS: DB2, Universe
OUTPUT : Html, Excel, PDF, Html(active)
 
Posts: 13 | Location: Kentucky, USA | Registered: August 16, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders