The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

DCarrillo's avatar
DCarrillo
New Contributor III
3 years ago

Zeroes into -

  I am trying to change the zeroes in my report to become '-'. Can I accomplish the above with an If Statement?  
Reports
TonyToniTone's avatar
TonyToniTone
Icon for OneStream Employee rankOneStream Employee
3 years ago

Have you tried adding something like this in the Cell Format under Number Format? 0;-0;"-"?  If you have a Custom Number Format, it follows the same formatting as Excel.  Excel Custom Number Format offers 4 arguments.  Argument 1 is for the Display of Positive Numbers, Argument 2 is for the Display of Negative Numbers, Argument 3 is for the Number Zero Format, and Argument 4 is for Text.  There are plenty of links on this subject online.  

Hope this helps

DCarrillo's avatar
DCarrillo
New Contributor III
3 years ago

How would I transform my zeroes into dashes in OS though?