Classic Screen Customization totals the Prepaid Invoice Deposits and fills a Text Box with the result

Do you see a number in TransView.PrepaidTotal column? If so it is left or right justified? I wonder if it’s a string vs number issue.

Yes

Everthing checks out my friend. I got nothing else to offer I’m afraid. Suppose you could try a regular text box, but your math is good and your bindings are good. Only thing I can think is something else is wiping out your TransView row after the calc or something is preventing standard binding from bubbling up to the box. I’m still most suspicious of the currency box tho.

Text box:

Yup. You could try looking around for this ToggleCurrency checkbox but I thought this only applied to grid columns. Eitherway its a bug.

Or it’s a string vs num problem - still a bug:

Everything I’ve heard about math applied to field values said that it would all be moved to Functions.
That’s why I took the approach I did.

Clearly there is more available in Expressions on the client side.

Thanks for taking time to step through this with me.
I really appreciate the help and the education.
Ben

1 Like

Thanks for taking time on my post, Nate!

1 Like

Some of us (perhaps me alone) tend to think calcs on local data meant for display purposes only doesn’t really qualify as ā€˜business logic’ belonging to server-side-only so we try to bring others to the client-side-first dark-side. :wink:

I don’t think of it as a client vs server-side thing. JavaScript uses floating point representations of numbers by default. If you’re careful about it, there’s no reason not to sum at the client.

Maybe @estm8ben is referring to something like this:

1 Like