1 Reply Latest reply on Feb 2, 2012 9:09 AM by susanacrespo

    This should be simple! How do you use two calculated fields to calculate a rate?

      I am working for a tall, normalized table where all my elements are in one column, and the value in another.  I want to select the sum value from one element (tonnes of agricultural production) and divide it by the sum value of a second element (hectares of harvested area) to calculate the rate of yield (tonnes per hectare)

       

      The details:

      Create = # Area Harvested:

      IF [element_txt] = "Area Harvested" THEN[val] ELSE NULL END

       

      Create = # Production Quantity:

      IF [element_txt] = "Production Quantity" THEN [val] ELSE NULL

       

      Both these calculations work.  However, if I want to create the = # Yield calculation by dividing one by the other, it comes out NULL.  Here is what I am using for the third calculated field:

       

      [Production Quantity]/[Area Harvested]

       

      Any ideas?