5 Replies Latest reply on Aug 30, 2014 5:15 PM by synergy46

    FM 13 Adv  global calculated fields using $$global variables

    synergy46

      It seems like this should be doable.....?

       

      FormalLayout.jpg

       

      The layout in design mode looks like this:

      LayoutEdit.JPG

      The top right field (gBalancePerStatement) is a user input field.

      The two fields below ($$DepositTotal and $$CheckTotal) are correctly calculated to be $155 and $1110 respectively.

      The problem lies with gEndingBalance which is a global calculated field defined as:

      gEndingBalance.jpg

       

      DataView1.jpg

       

      It seems that all the pieces are there..... 10000 - (gBalancePerStatement) - 1110 ($$CheckTotal) + 155 ($$DepositTotal = $9045

      NOT 8740

       

      Got any ideas of what is going on? What am I missing?

       

      Thanks

       

      Ron