Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums    Search    Search Results
Page 1 2 
Go
New
Search
Tools
Search Results: (21 matches) New Search Login/Join 

Discussion Topic  RE: [SOLVED] COMPUTEd field where clause. (in WebFOCUS/FOCUS Forum on Focal Point ) by jif26
Thanks. I guess I had sort of the same idea. This is what I did before I saw your post: TABLE FILE ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] COMPUTEd field where clause. (in WebFOCUS/FOCUS Forum on Focal Point ) by jif26
Couldn't I do something more simple by holding data for 2007 and another hold for 2008 (where diff >......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [SOLVED] COMPUTEd field where clause. (in WebFOCUS/FOCUS Forum on Focal Point ) by jif26
I'll explain with this example. Here's sample data along with a simple table file: KEY1 YEAR NUM1......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] WHERE clause on a computed field after an across. (in WebFOCUS/FOCUS Forum on Focal Point ) by jif26
Ok, here's how I did it. -* (WHERE &MONTH = 1 for Jan, 2 for Feb, ...) -SET &STARTCOL = &MONTH; -S......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] WHERE clause on a computed field after an across. (in WebFOCUS/FOCUS Forum on Focal Point ) by jif26
That's right, I would need to calculate against December (of the previous year of course). On the c......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] WHERE clause on a computed field after an across. (in WebFOCUS/FOCUS Forum on Focal Point ) by jif26
OK. After making something work, I have this issue using the technique above, there's one big show s......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] WHERE clause on a computed field after an across. (in WebFOCUS/FOCUS Forum on Focal Point ) by jif26
......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] WHERE clause on a computed field after an across. (in WebFOCUS/FOCUS Forum on Focal Point ) by jif26
Thanks John. The problem with your example is that you're losing the across field. No where in the ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [SOLVED] WHERE clause on a computed field after an across. (in WebFOCUS/FOCUS Forum on Focal Point ) by jif26
I'm calculating a difference between two fields under an across as such: TABLE FILE MAZCV SUM FIEL......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  ACROSS value sequences lost in OLAP (in WebFOCUS/FOCUS Forum on Focal Point ) by jif26
I want to report volumes across months in an unusual order (going from november to october). When do......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  Replacing multiple occurences of a value with another within a string (in WebFOCUS/FOCUS Forum on Focal Point ) by jif26
Is there an easy way in focus to replace multiple occurrences of a string within one string ?......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Replacing multiple occurences of a value with another within a string (in WebFOCUS/FOCUS Forum on Focal Point ) by jif26
Yes, I know that, but this doesn't help me with my issue....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  Replacing multiple occurences of a value with another within a string (in WebFOCUS/FOCUS Forum on Focal Point ) by jif26
Is there an easy way in focus to replace multiple occurrences of a string within one string ?......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  WF Browser : form submission with a lot of elements (in WebFOCUS/FOCUS Forum on Focal Point ) by jif26
I'll try to sum it up the best way possible.......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: WF Browser : form submission with a lot of elements (in WebFOCUS/FOCUS Forum on Focal Point ) by jif26
......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: WF Browser : form submission with a lot of elements (in WebFOCUS/FOCUS Forum on Focal Point ) by jif26
......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  Is there a way to make AUTOFIT width in Exl2k ? (in WebFOCUS/FOCUS Forum on Focal Point ) by jif26
Hi, is there a way to make AUTOFIT width in Exl2k without having to define the fields ? (much like S......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: How to find what SQL is generated (in WebFOCUS/FOCUS Forum on Focal Point ) by jif26
Darn! How stupid of me... Tried it on another table, worked. Thanks!...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: How to find what SQL is generated (in WebFOCUS/FOCUS Forum on Focal Point ) by jif26
......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: How to find what SQL is generated (in WebFOCUS/FOCUS Forum on Focal Point ) by jif26
Mmm...this doesn't work for me either. I'm using WF Browser 4.3.6......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point


» Refine Search
» New Search

  Powered by Social Strata Page 1 2  

Focal Point    Focal Point Forums    Search    Search Results

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