For adding the dollar sign, take a look at Simon Black's answer in https://forum.mendix.com/link/questions/8614:
Give your curreny field a unique css class. In your CSS, do the following:
.MyClass :before { content: '$'; left: -5px; }
Change the content property to the type of currency needed
For hiding the zero’s you can use the AppstoreApp CellGridStyler.
Thanks … For the grid styler, I’m not familiar with Javascript. I tried to google how I would camouflage zeros to blanks but didn’t get far. Any tips?