Getting the value of an expression and populating a text box?

[#1]

Hi, I need to populate a text box with the sum of all the balances in a column. I tried

=NUM(((sum(<table>.Balance) + [Expression Total]) * [Expression Rate]), '#,###.##', '.', ',')

But this seems to just return 0 in the text box even though it works in the table I am using. Any advice?

[#2]

I am wondering if it doesnt understand what the Expressions are... I get the message Bad Field Names in the expression definition panel.

[israrkhan]

try this

=NUM(((sum(Balance) + [Expression Total]) * [Expression Rate]), '#,###.##', '.', ',')

[#4]

I think that is what I am already doing... I get 'Bad Field Names' and a total of 0.

[israrkhan]

possible to share a sample...? would be easy to help...