Formatting cells with no data

Post Reply
dilip
Posts: 128
Joined: Thu Dec 15, 2011 8:22 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003

Formatting cells with no data

Post by dilip »

Hi,

How we can put '/' in our cube instead of 0 for no data in the source file.
User avatar
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

Post by Steve Rowe »

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,
Technical Director
www.infocat.co.uk
dilip
Posts: 128
Joined: Thu Dec 15, 2011 8:22 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003

TM1 Basic Question

Post by dilip »

Hi,

Can we display in cube view as '-' sign or hyphen i.e same in place of 0...Please suggest and how?
User avatar
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

Post by Steve Rowe »

Maybe did you read the documentation on formatting?
Technical Director
www.infocat.co.uk
Alan Kirk
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

Post by Alan Kirk »

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.
Agreed, this is getting ridiculous. Dilip, PLEASE READ the Request For Assistance Guidelines.

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.
dilip
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

Post by dilip »

sorry Alan for the inconvenience.....

I will be careful in future.
Post Reply