#N/A

Question

Post reply

#N/A

JKSQL

SSCrazy Eights

Points: 8481
More actions
April 12, 2006 at 8:48 am

#113674

I am confused about #N/A.
In excel the detail value (measure) is showing #N/A when there is a total. Something I am doing is wrong. I looked at the data and I have values.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ralf Bohne SSCommitted Points: 1531 More actions · Answer 1

Hi,

I've had this effect two times:

1. when a drill down was made deeper than the 5th level

2. when a measure was calculated as count distinct

point 1: excel works as designed. user e.g. DataWarehouseExplorer from CNS

point 2: I used count without distinct, but I had to make the keys unique

Regards

Ralf

JKSQL SSCrazy Eights Points: 8481 More actions · Answer 2

interesting it is at the 5th level. It is for an accounting breakdown

ie

1234 Management

5678 Salaries

8910 IT

2222 Expense

12345 taxable 12.12

56789 Non taxable #N/A

So it was weird that one line was #N/A and the other has a value.

I also made an Account dimension. It looked like this

56789 - 100.00

12345 - 12.12

Both had values. Is there anything I can do to get around it? Do I need to have two dimensions one going 2 levels and one going 3?interesting it is at the 5th level. It is for an accounting breakdown

ie