# SLP SLP: 請教如何顯示學生已退修

1. ### Miss Chung Expand Collapse

文章:
120
讚:
0
請教: 當我印今年中五的SLP時, 發現若學生於中四時修讀"經濟", 在升中五時因為修讀ApL而Drop了"經濟"
中四的經濟總分和得分也是有的, 只是在中五那些位置純粹是"空白", 不太好...

請問如何改那Formula以更出到"- - -"?
又或是可否set 到以今年修讀的科目追印中四的科目呢?
謝謝!

Miss Chung

yr2full:
case 'mark':
{Command.yr2full}
if (isnull({Command.yr2maxeng})=true and isnull({Command.yr2maxchi})=true)
then {Command.yr2full}
else -1
case 'both':
{Command.yr2full}
default:
{Command.yr2full}

yr2com:
if (isnull({@yr2score}) = true)
then {@yr2gd}
else
{@yr2score}

// case 'mark':
// if (isnull({@yr2score}) = true)
// then {@yr2gd}
// else
// {@yr2score}
// if (isnull({@yr2gd}) = true)
// then {@yr2score}
// else
// {@yr2gd}
// case 'both':
// if (isnull({@yr2score}) = true)
// then {@yr2gd}
// else if (isnull({@yr2gd}) = true)
// then {@yr2score}
// else
// {@yr2score} + chr(13) + {@yr2gd}
// default:
// if (isnull({@yr2score}) = true)
// then {@yr2gd}
// else if (isnull({@yr2gd}) = true)
// then {@yr2score}
// else
// {@yr2score} + chr(13) + {@yr2gd}

#1 Miss Chung, 2011-07-06
2. ### edb-石頭 Expand Collapse

文章:
1,160
讚:
0
老師請參考以下的語句。

yr2com:
if (isnull({@yr2score}) = false) then {@yr2score}
else if (isnull({@yr2gd}) = true) then '---'
else {@yr2gd}

yr2fullcom:
case 'mark':
if (isnull({@yr2full}) = false) then totext({@yr2full})
else
if (isnull({@yr2fullgd}) = true) then '---'
else {@yr2fullgd}
if (isnull({@yr2fullgd}) = false) then {@yr2fullgd}
else
if (isnull({@yr2full}) = true) then '---'
else totext({@yr2full})
case 'both':
if (isnull({@yr2full}) = true) and (isnull({@yr2fullgd}) = true) then '---'
else
if (isnull({@yr2full}) = true) then {@yr2fullgd}
else if (isnull({@yr2fullgd}) = true) then totext({@yr2full},0)
else totext({@yr2full},0) + chr(13) + {@yr2fullgd}
default:
if (isnull({@yr2full}) = true) then {@yr2fullgd}
else if (isnull({@yr2fullgd}) = true)
then totext({@yr2full},0)
else totext({@yr2full},0) + chr(13) + {@yr2fullgd}

#2 edb-石頭, 2011-07-08