Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gaddam.venugopal
Starting Member
1 Post |
 Posted - 2008-06-04 : 00:55:16
|
| HAI, ([Business Segment Master].[Main Group].&[Cash on Hand],[Measures].[Last Week Date Data])/([Business Segment Master].[Sub Group].&[Terminal Deposits],[Measures].[Last Week Date Data])This is the calculated measure iam using with MDX queries. iam getting NAN ,#ERROR in reports. i need help in this issue. it is very urgent.Thanks and Regards,venugopal. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-04 : 01:08:53
|
| NaN means not a number. Probably you could add some checking conditions to check the presence of numbers in your field values to avoid it.#ERROR indicates there is some error in the evaluation of your expressions. One of possibilities can be division by 0 error.Include an IIF condition to not perform division if denominator is 0 and try again. |
 |
|
|
|
|
|
Getting NAN, #ERROR, -1#IND IN REPORTS