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 |
|
tymemynt
Starting Member
2 Posts |
 Posted - 2008-10-22 : 23:22:54
|
| I have a calculated member called 'Average Rate'(AvgRt).In the pivot table, Average Rate for each month will be shown. But the problem is the total of AvgRt that's generated in the pivot table is different from the total that i did using manual calculation. I noticed that the pivot table show formatted value (e.g AvgRt in Feb is 3.53) but when i check in the cube, the figure is 3.534274994..so the total that was shown in the pivot table is the sum of the original value (e.g. 3.534274994), not the formatted value...what should i do to make the total is calculated using the formatted value? |
|
|
|
|
|
Format value problem