6 Replies Latest reply: Feb 11, 2016 10:01 AM by Priyanka Pandey RSS

    Calculation in staright Table

    Priyanka Pandey

      Hi All,

       

      I want to display data in straight table and data is in below format.

       

      I am getting values in point  format after calculating it from different fields and basis on this value (ans of that calculation) I want to map it with below table.

       

      for example if ans of calculation is = to 1.6 it must display 2, if ans is less than 1.5 it must display 1 and so on

       

      ValuePoints
      < = 1.51
      1.62
      1.73
      >=1.84

       

       

      Please help me in getting this output.

        • Re: Calculation in staright Table
          mayilvahanan ramasamy

          Hi

           

          Try like ths

           

          Points

          =If(Column(1) <= 1.5, 1.

               if(Column(1) = 1.6, 2,

               If(Column(1) = 1.7, 3, 4)))

           

          And Hide the Value Column in presentation tab, if its not required

           

          Hope it helps you

          • Re: Calculation in staright Table
            Michael Matern

            Hey,

             

            if you want to avoid results in point format e.g. 1.6 then you can use the round formula, eg round(6/4), the result is 2 not 1.5.

             

            I hope it will helps you!

             

            BR

            Michael

            • Re: Calculation in staright Table
              Priyanka Pandey

              Hi Everyone,

               

              I my scenario, i have 3 excel source in different data format

              excel one contains data in the format

                   [SR]:

              Manager NameEmployee NameMonth QuarterComm Type
              HardikPriyanka11First
              HardikMonika11Pre
              HardikSarvesh11First
              HardikAfsar11First
              HardikRam11Pre
              HardikSita11Pre
              AnisAkhilesh11Pre
              AnisRamesh11First
              AnisSaravana11First
              AnisPrashant11First
              AnisPrathamesh11Pre
              AnisAman11Pre
              AnisRahul11Pre
              HardikPriyanka21First
              HardikMonika21First
              HardikSarvesh21Pre
              HardikAfsar21Pre
              HardikRam21Pre
              HardikSita21Pre
              AnisAkhilesh21Pre
              AnisRamesh21First
              AnisSaravana21Pre
              AnisPrashant21Pre
              AnisPrathamesh21First
              AnisAman21First
              AnisRahul21First

              in the above table we have to load where comm type = 'Pre'

                    [Paid]:

              Manager NameEmployee NameMonth Quartercount
              HardikPriyanka111
              HardikSarvesh111
              HardikRam110
              HardikSita111
              AnisAkhilesh110
              AnisRamesh111
              AnisSaravana111
              AnisPrashant110
              AnisPrathamesh111
              AnisAman111
              AnisRahul110
              HardikPriyanka211
              HardikSarvesh211
              HardikRam210
              HardikSita211
              AnisAkhilesh211
              AnisRamesh210
              AnisSaravana210
              AnisPrashant210
              AnisPrathamesh210
              AnisAman210
              AnisRahul211
              HardikPayal310
              HardikMohan314

               

              and score table as shown in first message.

               

              Score of every employee  is calculated as follows Sum(Count) / count(Comm Type).

              I am unable to achieve this in backend and that the reason i calculated it straight table and want to map each partners value in frontend