2 Replies Latest reply on Sep 22, 2015 11:13 AM by Al Vish

    creating calulation between joined tables

    Al Vish

      I have set up a relationship between two excel tables.  Im trying to run a simple calculation between two fields, one in each table (just dividing one record by the corresponding record in the other table).


      The calculation I created is:


      SUM([Treatment Summary (test for navport replacement)].[Total Proppant (lbs)])/SUM([LL])


      Some questions:


      1 - When I check the data source that has the custom calculation, I see the calculated field added, but all the values are 'null'.


      2 - Charts that reference these calculated values are incorrect.


      3 - What formula can I write to perform the calculation ONLY if a cell in the field [LL] is not blank?


      As far as the result, all I want to do is divide the cell value in the field [Total Proppant] by the cell value in the field [LL], where it is not blank..