5 Replies Latest reply on Feb 16, 2017 5:45 AM by Richard Kevin Silva

    FIXED-SUM-IF Help

    Richard Kevin Silva

      Company_Name | Actual_Count | Count_Per_Day_Wrong (Actual_Count/14)

      CompanyA | 1 | 0.07

      CompanyB | 1171 | 83.64

      CompanyC | 77 | 5.50

      Total ---- 89.21 (Value will be 89 because it will be summed first before rounding)

      Company_Name | Actual_Count | Count_Per_Day_Correct (Actual_Count/14)

      CompanyA | 1 | 0 (value is rounded)

      CompanyB | 1171 | 84 (value is rounded)

      CompanyC | 77 | 6 (value is rounded)

      Total ---- 90 (value is 90 because rounding occurred in Company level before getting the sum)

      My current calculated field is:

      ROUND(ROUND( (SUM(IF [Container] = 'LargeContainer' THEN [Weight] END)) / COUNTD([Date]),2)) 

      This calculated field returns the value mentioned in the 1st table. How can I have the values rounded first by Company level then have the sum?

      PS. Apologize if I can't explain it very well. Hope you guys can still understand the situation.