Representing 0 as a hyphen

Join the general discussion on using Quantrix Modeler.

Moderator: Moderators

Representing 0 as a hyphen

Postby ltaber » Sun Feb 10, 2008 9:52 pm

How do I get Quantrix to enter a symbol such as a hyphen or a period instead of entering a zero value for the result of some formula?
ltaber
Quantrix Forum Member
 
Posts: 19
Joined: Sat Jan 12, 2008 10:10 am

Postby dom » Mon Feb 11, 2008 5:26 am

Itaber,

I have played around with one idea but it is far away from being perfect:
Create a formula that is eclipsing all previous formulas in your matrix. In this example, the formula is:
Product = IF(Month[THIS]= 0, "-",Month[THIS])

The issue is that it is involved in one more circular references what might be an issue.

I have attached the sample file.
As I said, not the perfect solution but perhaps a base for better ideas.
Another idea is to use color coding with conditional formating.

Dominik
You do not have the required permissions to view the files attached to this post.
dom
Quantrix Forum Member
 
Posts: 155
Joined: Tue Dec 20, 2005 2:41 am
Location: Zurich, Switzerland

Postby Quantrix QA » Mon Feb 11, 2008 9:10 am

You could also apply the accounting alignment format to the cell. Format > Number, and check off the Accounting Alignment check box. That will enter a "-" for zero's.

-Mike
Quantrix QA
 

Postby dom » Wed Feb 13, 2008 8:19 am

Mike,

Thank you for the useful hint!

Dominik
dom
Quantrix Forum Member
 
Posts: 155
Joined: Tue Dec 20, 2005 2:41 am
Location: Zurich, Switzerland

Re: Representing 0 as a hyphen

Postby mgandy » Mon Apr 03, 2017 3:43 pm

I thought about creating a new thread, but decided to use this one as it aptly applies and will make it easier for future searches if this same question arises.

I'm using Version 6.4.1 and I'm having a difficult time in making my zeros be hyphens.

What am I not doing? See attachment.

Thanks,
Mark
You do not have the required permissions to view the files attached to this post.
Mark Gandy
mgandy
Quantrix Forum Member
 
Posts: 11
Joined: Mon Aug 11, 2014 8:50 pm

Re: Representing 0 as a hyphen

Postby James K » Wed Apr 19, 2017 7:13 am

We are aware of this issue and it appears to be caused by having an older version of the Lato font installed on your machine. You can work- around this issue by either uninstalling the Lato font or by installing the most recent version from here: http://www.latofonts.com/lato-free-fonts/#download

Kind Regards,

James
James Kipling
Product Manager, Quantrix
Official Quantrix support is provided through the IDBS Help Desk via support@quantrix.com
James K
Quantrix Forum Member
 
Posts: 28
Joined: Thu Dec 12, 2013 8:20 am


Return to General Discussion

Who is online

Users browsing this forum: Google [Bot] and 1 guest