This has to be dead easy but I’m not getting it. What is the easiest way to get the total of a floating point field to display as dollars and cents in a text display object?
I have #.,## selected under output pattern under field properties in the sheet, and it displays correctly in the sheet.
For the TDO I have the field name in the Formula. I tried to apply a pattern to the formula but no luck.
When I run my procedures that create the total, sometimes it displays correctly and sometimes throws in 3-5 extra decimal places. Seems random.
I also found some notes from Jim on changing the blueprint but my one small attempt to tinker with that was rejected. A little knowledge etc. etc.