게시판을 이용해 주셔서 감사합니다.
다음양식에 맞게 입력해주세요.

* 고객시스템명 :
* GAUCE 버전 : GAUCE_JAVA_4.0.3.5
* WAS 종류(WebLogic 등등) :
* DB 종류 : MSSQL2005
* 문의 유형(질문/요청/참조) :
원가율과 수율 부분으로 --> 원가율은 (금액/원가)*100를 계산해서 화면에 표시해주어야 합니다.
sumtext 와 subsumtext 를 각각 계산한값을 화면에 나타나야 하는데 subsumtext 에도 sumtext 의 값이 나타납니다.
(연락처 : 010-7180-2068)

* 내용 :

function gridCreate(){

    var hdrProperies = '<FG> name="메뉴 정보" '
                                     + '<F> id=MENU_CATNM        name="메뉴분류"         align=center width=110  subsumtext = "소계"  </F>'
                                     + '<F> id=MENU_CD                name="메뉴코드"         align=center  width=70 </F>'
                                     + '<F> id=MENU_NM                name="메뉴 명"          align=left  width=150  SumText="합계"</F>'
                                     + '</FG>'
                     + '<G> name="판매"'
                     + '<C> id=DANGA             name="단가"        align=right width=70 subsumtext=""</C>'
                     + '<C> id=SALE_QTY            name="수량"        align=right width=50 SumText=@sum </C>'
                     + '<C> id=SALE_AMT     name="금액"        align=right width=115 SumText=@sum</C>'        
                     + '</G>'
                     + '<F> id=COST_AMT         name="표준원가" align=right width=110 subsumtext=""</F>'
                     + '<G> name="이론"'
                     + '<C> id=THEO_AMT     name="원가"        align=right width=120 SumText=@sum </C>'
                     + '<C> id=THEO_RATE        name="원가율"        align=right width=90 Dec=2 SumText={ round( decode( sum(SALE_AMT),0,0,(sum(THEO_AMT)/sum(SALE_AMT)*100)),3)} subsumtext={ round( decode( sum(SALE_AMT),0,0,(sum(THEO_AMT)/sum(SALE_AMT)*100)),3)}</C>'
                     + '<C> id=THEO_ADD     name="이익"        align=right width=110 SumText=@sum</C>'        
                     + '</G>'
                     + '<G> name="실제"'
                     + '<C> id=ACT_AMT      name="원가"        align=right width=120 SumText=@sum</C>'
                     + '<C> id=ACT_RATE            name="원가율"        align=right width=90 Dec=2 SumText={ round( decode( sum(SALE_AMT),0,0,(sum(ACT_AMT)/sum(SALE_AMT)*100)),3)} subsumtext={ round( decode( sum(SALE_AMT),0,0,(sum(ACT_AMT)/sum(SALE_AMT)*100)),3)}</C>'
                     + '<C> id=ACT_ADD            name="이익"        align=right width=110 SumText=@sum</C>'        
                     + '</G>'
                     + '<F> id=SU_RATE                name="수율" align=right width=70 SumText=@sum SumText={ round( decode( sum(ACT_AMT),0,0,(sum(THEO_AMT)/sum(ACT_AMT)*100)),3)} subsumtext={ round( decode( sum(ACT_AMT),0,0,(sum(THEO_AMT)/sum(ACT_AMT)*100)),3)}</F> '
                                     ;                                                         
    gridInit(GR_Main, "DS_Main", hdrProperies);
        DS_Main.SubsumExpr  = '1:MENU_CATNM';//소계보이기
        GR_Main.ViewSummary = "1"; //합계 보이기  

}