6 Replies Latest reply on Oct 4, 2018 6:28 AM by William Brown

    Showing This Months Work and Left Over Last Month work on the same worksheet

    William Brown

      I have a worksheet where I want to show this months work and the remainder of last months work and add it to show a total of what needs to be completed this month.  I have a field I calculate in a SQL Query to show [Work], but for the life of me I cannot figure out how to create a calculated field that would display only last months work

       

       

                                                  Oct

      Past Due Work                    500

      Current Month Work         5,000

      Total Work for the Month  5,500