3 Replies Latest reply on Feb 23, 2016 9:52 AM by Alec Barrett

    Formula giving incorrect response depending on graph

    Aryn Anselm

      I'm using the following formula in 2 different charts from 2 different data sources. The data sources match perfectly in totals, they're just sorted differently based on needed sort functionality.

      The formula is sum(Events*200000)/sum(Mileage)

      Both files have the following data :

      Events 112

      Mileage 2115757

      In one graph I get the correct answer of .93 but the other says .91. I have been trying for hours but I cannot figure out why the rates are showing differently. Does anyone have any ideas how I can correct this? Any help is appreciated!!