I am not seeing how to justify symbols to the left or right. For instance, instead of "$100", I want to left justify the dollar symbol to "$ 100" such that all of the dollar symbols line up in a columns. Thank you for your help.
Right click the column -> format -> in "Number" tab, write $ then space in the prefix field.
Another way: Right click the column -> conditional format -> add condition -> if "current sell value" > value 0, add the format as above.
It's preferred to post on "Hyperion Query and Reporting" community
Hyperion Query and Reporting
Thanks & Regards,