Hey guys, I have been trying to solve this dilemma for months now. I need a row format code, numeric, that will let me round to the whole thousand and give me a "-" for zero amounts? any help would be awesome.
*This post is locked for comments
Hey guys, I have been trying to solve this dilemma for months now. I need a row format code, numeric, that will let me round to the whole thousand and give me a "-" for zero amounts? any help would be awesome.
*This post is locked for comments
Hello Dan,
Here is what I did to get that result.
1. I had to set rounding at the report definition level to thousands.
2. Any rows I didn't want rounded to the thousands in the row definition I added print control of SR (Suppress Rounding).
3. I added a format override to the row and in that window specified - for zero.
Let me know if that works for you,
Thanks,
April
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,269 Super User 2024 Season 2
Martin Dráb 230,198 Most Valuable Professional
nmaenpaa 101,156