Focal Point
ACROSS and COLUMNS

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6131021882

June 16, 2008, 02:51 PM
CherylB
ACROSS and COLUMNS
Summing values across dates, even if only 9 months have data, but I need across 12 months, the rest of the columns should show zero data.

I have researched this in Focal Point, found a log on 02/09/2006 with the same problem. I started with using the PERSINFO file (as the example showed) and it worked. Here's what I typed:

DEFINE FILE PERSINFO
BIRTH_MONTH/MT=BIRTHDATE;
END
TABLE FILE PERSINFO
SUM CNT.PIN ROW-TOTAL
BY COUNTRY
WHERE BIRTH_MONTH GT 6
ACROSS BIRTH_MONTH
COLUMNS '07' AND '08' AND '09 AND '10' AND
'11' AND '12' AND '01' AND '02' AND '03' AND
'04' AND '05' AND '06'
END

I created most of the code using the GUI and then had to type the COLUMNS code in to the Text Editor because I don't know where to find COLUMNS from the GUI enviornment. Or, is this code you have to type and not use GUI?
I am using WebFOCUS 764.


WF 7.7
Unix/Tomcat
ZLinux on System Z
DB2 Relational DB
June 16, 2008, 03:38 PM
TexasStingray
That's correct the gui does not support it at this time. NOTE: if you bring it back up in the gui you will loose your columns




Scott

TexasStingray,
Thank you for confirming this for me. I did lose my code and I had to retype, but I needed to confirm this. Will there be a fix for this in the near future? This code is very helpful.


WF 7.7
Unix/Tomcat
ZLinux on System Z
DB2 Relational DB
Open a case with NY Support and ask that question of them.




Scott