we have a requirement in Financial Reporting.
1)If the Transaction value is 0 then i need to show the value $ followed by 9 blank spaces hyphen (-) and 8 blank spaces.
2)If the Transaction value is XX then i need to show the value $ followed by spaces and Amount xx.
If the Transaction value is ex: 1234.29 it should occupy in the blank columns like $ followed by 14 blank spances and Amount.
I have applied Data Formatting and selected "Currency" it is not workout.
It is not occupying Amount field in the spaces provided.
If anybody has worked on these types of scenarios, Please let me know how to do it.
Thanks In Advance.