1 Reply Latest reply on Aug 14, 2012 8:09 AM by LaRetta_1

    Calculation problem ,,, How to fix this type of calculations ?

    applelakshan1

      Title

      Calculation problem ,,, How to fix this type of calculations ?

      Post

      Hello guys, 

      I am Working on FileMaker 11 Ad, 

       

      This is my problem , 

       

      I have 01 table with 300+ records , this table have 2 fields, called  01 Account number , Account total 

      Lets say  we have 10 records (for example)

      Account number:  0102 030405060708 0910 (records)

      Account Total :101520781921121013

      I need to count sum of Account Total in  record number 01 and records number 02  and record number 09 and this will store in another field,

      So answer should me 10+15+10 =35

      Please help me to find how to acomplish this

        • 1. Re: Calculation problem ,,, How to fix this type of calculations ?
          LaRetta_1
          What makes record numbers 01, 02,  and 09 different from the other records?  You must use this difference.  For instance, if they are Type = Expense and the other records are Type  = Income then you create a calculation similar to:  Case ( Type = "Expense" ;  Account Total ) Then create a summary for this calculation.  You can also filter your relationship by creating a self-join and joining Accounts::Type = Accounts 2::Type or by filtering your portal ... but it would help to know what this sum represents and where it will used.  You might need a structure adjustment.