Expand my Community achievements bar.

Calculation Script

Avatar

Level 1

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 

2 Replies

Avatar

Level 10

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

Avatar

Level 1

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