Hi,
I have 2 tables, t1 and t2. Did left outer join on t2. Did use crosstab in my report. I created a formula as below,
IF not(isnull({t2.STUDENT})) THEN
IF (not ({t2.CODE} in [2050, 2130]) and {t1.ESE} = "Y" and {t2.PLACE} in ["1", "4", "5"])
THEN "ESE"
ELSE
IF ( {t1.ESE} = "N" or
( {t1.ESE} = "Y" and
({t2.CODE} in [2050, 2130] and {t2.PLACE} <> ["1", "4", "5"])
)
) THEN "NON-ESE"
ELSE ""
else
IF ( {t1.ESE} = "N" or
( {t1.ESE} = "Y" and
({t2.CODE} in [2050, 2130] and {t2.PLACE} <> ["1", "4", "5"])
)
) THEN "NON-ESE"
ELSE "ESE"
There is an extra column along with "ESE" and "NON-ESE" column, which should not be and sum of (extra column + "ESE" and "NON-ESE" column) is more than the Total.
Things that need to be fixed,
1. There should be only 2 columns, "ESE" and "NON-ESE"
2. The total should match
Can someone please help me in this. Thanks.
Edited by flower - 01 Jul 2015 at 9:06am
|