是否有指令的順序,在所有的 ”總” 和 “定義字” 前 可以做嗎?
如果我這樣做:
TOTAL FIELDS Bank_Market_Value
v_TMV = TOTAL1
TOTAL FIELDS PAM_Market_Value
v_PMV = TOTAL1
both v_PMV and v_TMV are set correctly (and differently) and all is good. but if I do other stuff in between such as this:
TOTAL FIELDS Bank_Market_Value
v_TMV = TOTAL1
DEFINE FIELD v_FP_TMV COMPUTED (.0005*v_TMV)
set filter ABS(PAM_Market_Value - Bank_Market_Value ) > v_FP_TMV
EXPORT FIELDS Sec_Desc PAM_Sec_ID PAM_Market_Value Bank_Market_Value v_FP_TMV DELIMITED TO "C: empIM_Auditoutput_files
ewscript1" KEEPTITLE SEPARATOR "," QUALIFIER '"'
DEFINE FIELD v_two_basisPTS COMPUTED (.002*v_TMV)
TOTAL FIELDS PAM_Market_Value
v_PMV = TOTAL1
set filter ABS(v_PMV-v_TMV) > v_two_basisPTS
EXPORT FIELDS Sec_Desc PAM_Sec_ID PAM_Market_Value Bank_Market_Value XLS21 TO "C: empIM_Auditoutput_files
ewscript2"
export FIELD v_two_basisPTS v_TMV v_PMV XLS21 TO "C: empIM_Auditoutput_files est10_%v_name%"
then TOTAL1 and v_PMV are always 0.00. Yet if I go back in the log and run the second "TOTAL FIELDS" manually and then do a "dis var", it's correct.
請幫忙看一下 謝謝!
| 3 |
| |
|