Microvellum Community

Sum of Data Containing "Right", "Left", and "Middle" (Report Designer)

Can someone help me figure out how to calculate the sum of data in the 'code' tab containing a certain word? I need this because in {Subassembly.Comments}, we modified our comments formula in our subassembly workbook so I have drawers that come in "Top Left Drawer Box", "Second Left Drawer Box" .... "Bottom Right Drawer Box (last)" and I need a formula like this, issue is that leftCount, rightCount, middleCount doesn't count each occurance of right, left, and middle which is needed for this to work: 


So that I have a dynamic drawerOrder based off of how many drawers are in each row of our cabinet (3x7 max array). This way the drawers are automatically numbered how we want them (DR-01, DR-02, ..., DR-N). Right now I've got the formula to do it where the drawer order is static, which won't work becuase even if I have two drawers (a left and a right), I'll get DR-01, DR-15 which isn't how we number our drawers. We number from top left to bottom right.

    MVU eLearning



    Grow Your Knowledge
    Follow along with RJ as he takes you on a journey to build your foundational knowledge of Toolbox.


      Follow us on:

               

        ERP for Millwork Shops


        Discover how Microvellum and INNERGY streamline operations for cabinet shops and millwork manufacturers.