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

Topics: Resolved
Feb 8 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 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: -