2 Replies Latest reply: Apr 22, 2013 4:42 AM by LT.ora RSS

    Need to compare individual emp sal and compare dept salary

    LT.ora
      Please help

      http://apex.oracle.com/pls/apex/f?p=10037:2:101071080066949::NO tab:  Grouping test
      demo/1234

      How to: keep a check box on summary row ( Aggregated total row )
      Need   : compare individual emp sal and compare dept salary
        • 1. Re: Need to compare individual emp sal and compare dept salary
          fac586
          LTaura wrote:
          Please help

          http://apex.oracle.com/pls/apex/f?p=10037:2:101071080066949::NO tab:  Grouping test
          demo/1234

          How to: keep a check box on summary row ( Aggregated total row )
          Need   : compare individual emp sal and compare dept salary
          Understanding the question is what is "totally impossible" here. What do you mean by "compare"? Compare what? How? What does this have to do with checkboxes?

          -----

          Please read the FAQ and forum sticky threads.

          You'll get a faster, more effective response to your questions by including as much relevant information as possible upfront. This should include:

          <li>Full APEX version
          <li>Full DB/version/edition/host OS
          <li>Web server architecture (EPG, OHS or APEX listener/host OS)
          <li>Browser(s) and version(s) used
          <li>Theme
          <li>Template(s)
          <li>Region/item type(s)

          As well as a clearly stated definition of the problem: +How to ask questions+
          • 2. Re: Need to compare individual emp sal and compare dept salary
            LT.ora
            Thanks for the reply Paul,

            There is similar requirement and same configuratoin so took the example of emp and dept and made an application on apex.oracle.com
            could you please have a look at the given link : http://apex.oracle.com/pls/apex/f?p=10037:2:101071080066949::NO demo/1234

            the need is a check box as show in http://tinypic.com/r/23sgk90/4


            the comparision code in javascript is :
            ...
                if (document.wwv_flow.f40.checked==true){
            str = document.wwv_flow.f40[i].value ;
            rDetails = str.split(",");
            rsal=parseFloat(rDetails[0]);
            for (j=i+1; j < document.wwv_flow.f40.length; j++)
            {
            if (document.wwv_flow.f40[j].checked==true)
            {
            str = document.wwv_flow.f40[j].value
            cDetails = str.split(",");
            csal = parseFloat(cDetails[0]);
            if(rsal > csal)
            {
            per=100 - csal * 100 / rsal ;
            output=output+ '<h4>' + rDetails[1] + ' Better than ' + cDetails[1] + ' ' + parseFloat(per.toFixed(2)) + ' % <h4/>';
            }
            else
            {
            per= 100 - rsal * 100 / csal ;
            output=output+ '<h4>P' + cDetails[1] + ' Better than ' + rDetails[1] + ' ' + parseFloat(per.toFixed(2)) + ' % <h4/>';
            }
            ...