synergy46

FM 13 Adv  global calculated fields using $$global variables

Discussion created by synergy46 on Aug 8, 2014
Latest reply on Aug 30, 2014 by 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

Outcomes