2 Replies Latest reply: Feb 12, 2011 11:34 AM by GESYMSB RSS

    Calculation Script

    GESYMSB Community Member

      Hello folks, I am experimenting with LightCycle Designer ES 8.2 and
      always getting an error when trying a calculation.

       

      Can you folks indicate me how to do it ?

       

      This is an example of what I want:

       

      Last Cell, should display the result of adding Value 1 plus Value 2 then multiply by 2

       

       

      Something like this: ( V1 + V2 ) * 2   

       

      As you can see there are 2 calculations, first add V1 plus V2 and the result is multiplied by 2

       

      Thanks 

        • 1. Re: Calculation Script
          Srini Dhulipalla Community Member

          You can place the below code in the Calculate event of the last cell.

           

          ( V1.rawValue + V2.rawValue ) * 2

           

          where V1 and V2 are the names of the fields you want to sum.

           

          Thanks

          Srini

          • 2. Re: Calculation Script
            GESYMSB Community Member

            10000000000 OF THANKS !

             

            Perfect, now do you think you can help me with this.

             

            Most calculations are perfect but look this example:

             

            Sub-total  69.54
            Labor       65.00
            Tax           6.727   ( Sub + Labor  times  0.05 )
            Total Service 141.27

             

            Total Service, should be .26 and not 27
            this is because the tax ( 6.727 )

             

            Anyway to fix that micro error ?

             

            Thanks