0 Replies Latest reply on Oct 20, 2013 7:10 AM by shae1725

    Help with a Calculation

    shae1725

      Title

      Help with a Calculation

      Post

           Let (
                  L = List ( A ; B ; C ;D ) ;
                 Case (
                 IsEmpty ( Self ) ; Get ( ActiveFieldContents ) ;
                 Self
                 )
           )

           I have this calculation already in fields A;B;C;D  used to populate the four fields if empty.

           I want to be able to add more features but not sure how!

           I need to add the following calculation

           Record 2    =   Record 1 -  FieldX(Record2)

           Record 3   = Record 1  - ((FieldX(Record2) + FieldX(Record3))

           Record 4    =  Record 1 - ((FieldX(Record2) + FieldX(Record3) +FieldX(Record3))

           etc etc

           (will ever only be approx  2 - 10 records)

            

           ie

           Record 1       fieldA (100)     fieldB(100)      fieldC (100)      fieldD (100)    fieldX (will always be empty)

           Record 2       fieldA (90)        fieldB(90)       fieldC (90)        fieldD (90)      fieldX (10)

           Record 3       fieldA (85)        fieldB(85)      fieldC (85)        fieldD (85)       fieldX (5)

           Record 4       fieldA (70)        fieldB(70)      fieldC (70)        fieldD (70)       fieldX (15)