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 |
|
coultard1
Starting Member
4 Posts |
 Posted - 2004-10-22 : 01:34:20
|
| I have created a calculated measure that is the percentage difference between 2 values.In the olap report\pivot table within excel this sometimes produces values of #NUM! in the calculated measure cell as the dividing value is zero.Is there any way to make the calculated measure show as 0?If have tried using Iif-numeric function, which changes it to 0, but in the report it then shows all values from dimensions that are not part of the report header group. |
|
|
|
|
|
replace #NUM! in calculated measure result