I have tried using ADCRONLY to return the withdrawals (transfers to checking) from a bank savings account. It consistently returns 0.00. Just for grins, I tried ADCREDIT, which also returns 0.00. Just for more grins, I tried ADDEBIT and ADDRONLY. These two returned the ending balance for the period. Below are the formulas I used (straight from the example in the help file):
=ADCRONLY("GLDATA.BAL",$B9) returns 0.00 (expected $16,000.00)
=ADCREDIT("GLDATA.BAL",$B9) returns 0.00
=ADDEBIT("GLDATA.BAL",$B9) returns $35,572.45
=ADDRONLY("GLDATA.BAL",$B9) returns $35,572.45 (expected $13,018.49)

The value in $B9 is 1010-` and is generated by .RANGE on a Smartsheet report. We retreive using classes as departments. I have tried hard-coding the account in the formulas as =ADCRONLY("GLDATA.BAL","1010:1010") and get the same result. I've also tried, just for grins and since I like to grin, other data fields such as OPEN, CURBAL, etc. Still no luck. Looking at the account data, it blows my mind. But that's probably another question for another thread.

I've tried to give as much info as I can, but I'm sure I left out a critical piece. Any help getting ADCRONLY and ADDRONLY to work is greatly appreciated.

Thanks,

Tim