3 Replies Latest reply on Sep 23, 2014 3:24 PM by philmodjunk

    Calculation for totaling information in one field



      Calculation for totaling information in one field


      Not sure how to ask this question, but I have a database that in one layout, there are four main fields, but they have much data associated with them. What I'm trying to do is group certain departments together so their area numbers total together. The image provided shows to different views, one is what the fields are in layout mode and the other one, I've circled an example, of the 3 areas that I would like to total together. What's the best way to do a calculation for this that hopefully, I can use for other groupings? Or what's the best way this should be done? Any help is greatly appreciated. Thanks.