Rounding in cube views
Hi there,
We need to see cube view figures which are rounded to an integer. Could you please advise how to round figures in cube view?
Forum Discussion
Joakim,
Thank you! I see now that visually in cube view figures are rounded to the nearest whole number. However, when I open cube view in Excel, I see in cells that figures contain decimals. Could you please advise is it possible to round these figures to the full numbers in Excel (as if we apply to each figure ROUND(,0) function)?
Irina,
In the same fashion, in the format section of the row/column, change the ExcelNumberFormat to be what you want. In my example it could for example be set to this: "ExcelNumberFormat = [#,##0]"
Regards, Joakim