This project has moved. For the latest updates, please go here.

Returns "#VALUE!" if member contains ' - '

Topics: Resolved
Feb 8, 2012 at 12:51 PM

Hi,

Very nice tool!

 

For your info : I noticed that when a measure in a Calculation contains a ' - ' character (example : "Customer Invoice Transaction - Count"), the calculation returns "#VALUE!"

I tried ignoring the character in the formula, replacing with : "Customer Invoice Transaction Count"

=> result is OK

Kind regards,

 

François

Coordinator
Feb 8, 2012 at 9:59 PM

Can you capture the MDX query and run it in Management Studio? After you do that, you should be able to double click the error cell and see the error message, which should help debugging.

Is it possible that you have a long dash in one place but not the other. (If you type a double dash in Word, then it will replace it with a long dash.) Try out the following two characters to see if either works:

Long dash: –
Short dash: -

Marked as answer by furmangg on 6/9/2014 at 4:03 PM
Coordinator
Jun 9, 2014 at 11:03 PM
There is also a feature in this add-in to help you see the #VALUE! errors:
https://olappivottableextend.codeplex.com/wikipage?title=View%20Error%20Message&referringTitle=Home
Marked as answer by furmangg on 6/9/2014 at 4:03 PM