9 Replies Latest reply: Sep 21, 2017 4:31 AM by Stephen Hasson RSS

    Confused on 'sum' function

    Stephen Hasson

      Hi,

      I cannot figure out why one bar graph on a sheet work perfecty and another, looking at the same field, 'doubles up'.....  I show in attached.

       

      I have verified that 3116 hrs of labour is accurate. In the top summary graph it used 'Sum(EstProdHours)' but gives inflated figured. If I change only use EstProdHours then I get nothing.

       

      The summary is ok once I select a specific job, but when all jobs are required to be shown, the figures are wrong.

       

      Thanks.