Hi,
How we can put '/' in our cube instead of 0 for no data in the source file.
Formatting cells with no data
- Steve Rowe
- Site Admin
- Posts: 2464
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: TM1 Basic Question
1. Please don't give all your queries the same topic it makes it look like you are duplicate posting and makes it likely that your queries will get deleted.
I think it is impossible to get a numeric cell in a cube to display / since this text, try reading the section on formatting and see if you can get a clue there.
Cheers,
I think it is impossible to get a numeric cell in a cube to display / since this text, try reading the section on formatting and see if you can get a clue there.
Cheers,
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- Posts: 128
- Joined: Thu Dec 15, 2011 8:22 pm
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2003
TM1 Basic Question
Hi,
Can we display in cube view as '-' sign or hyphen i.e same in place of 0...Please suggest and how?
Can we display in cube view as '-' sign or hyphen i.e same in place of 0...Please suggest and how?
- Steve Rowe
- Site Admin
- Posts: 2464
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: TM1 Basic Question
Maybe did you read the documentation on formatting?
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: TM1 Basic Question
Agreed, this is getting ridiculous. Dilip, PLEASE READ the Request For Assistance Guidelines.Steve Rowe wrote:1. Please don't give all your queries the same topic it makes it look like you are duplicate posting and makes it likely that your queries will get deleted.
I've renamed most of the threads and have merged two which were basically two flavours of the one question.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- Posts: 128
- Joined: Thu Dec 15, 2011 8:22 pm
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2003
Re: Formatting cells with no data
sorry Alan for the inconvenience.....
I will be careful in future.
I will be careful in future.