I'm new to posting here and please forgive me if my lingo is incorrect in my topic name or something I post below. I use Webfocus 7.7
I work at a University and am trying to execute something normally I do in Excel in web focus. Typically I use something like this in Excel
IF(AND(A2=A1,B2=B1),2,1)
Basically, this tells me if the student ID & course code are the same (assuming correct sorting) then I have a student repeating a course.
I'm trying to do it with something like:
TERM_COUNT/I2 = IF (SHRTCKG_PIDM EQ LAST SHRTCKG_PIDM) AND (COURSE_CODE EQ LAST COURSE_CODE) THEN 2 ELSE 1 ;
But I keep getting errors like:
(FOC258) FIELDNAME OR COMPUTATIONAL ELEMENT NOT RECOGNIZED: TERM_COUNT (FOC009) INCOMPLETE REQUEST STATEMENT
Any thoughts on how to fix it?
CODE:
SET BYDISPLAY = ON TABLE FILE GRADE_DISTRIBUTION_FINAL BY SHRTCKG_PIDM BY FEE_TYPE BY ACADEMIC_YEAR BY SHRTCKG_TERM_CODE BY COURSE_CODE BY SHRTCKG_GRDE_CODE_FINAL BY GRADE_VALUE WHERE COURSE_CODE EQ 'ENGL-105' OR 'CMNS-155'; ON TABLE SET PAGE-NUM NOLEAD ON TABLE NOTOTAL ON TABLE HOLD AS AA FORMAT ALPHA ON TABLE SET HTMLCSS ON END
JOIN LEFT_OUTER AA.AA.SHRTCKG_PIDM IN AA TO MULTIPLE SORHSBJ.SORHSBJ.SORHSBJ_PIDM IN SORHSBJ TAG J0 AS J0 END JOIN INNER J0.SORHSBJ.SORHSBJ_SBJC_CODE IN AA TO MULTIPLE STVSBJC.STVSBJC.STVSBJC_CODE IN STVSBJC TAG J1 AS J1 END
SET BYDISPLAY = ON TABLE FILE AA BY SHRTCKG_PIDM BY FEE_TYPE BY ACADEMIC_YEAR BY SHRTCKG_TERM_CODE BY COURSE_CODE BY SHRTCKG_GRDE_CODE_FINAL BY GRADE_VALUE BY TERM_COUNT/I2 = IF (SHRTCKG_PIDM EQ LAST SHRTCKG_PIDM) AND (COURSE_CODE EQ LAST COURSE_CODE) THEN 2 ELSE 1 ; ON TABLE SET PAGE-NUM NOLEAD ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ENDThis message has been edited. Last edited by: <Kathryn Henning>,
December 04, 2013, 03:24 PM
Waz
You are not allowed to do calculations on sort fields.
You will need to add this to a compute or define.
You also may need to do this in two steps, but you can try using compute, then BY TOTAL with TERM_COUNT.