Skip to main content
I
Irina
December 29, 2024
Solved

Rounding in cube views

  • December 29, 2024
  • 3 replies
  • 0 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?

 

Best answer by Paulo_Thrige

This is a functionality that a lot of organizations are looking for, as the reconciliation process of rounding numbers in related tables in external reports takes up a lot of manual resources or complex coding. I've seen a solution some years ago in a competing product, that could do the calculations and stored it as a separate layer in a UD. As I understand, it's algebra math and settling where to put the rounding discrepancies so it sill makes sense.
I think it would be a great business opportunity for the consulting community.

3 replies

J
JoakimK
December 30, 2024

In the formatting of the row/column, you can change the number format to N0, then it will display the data as whole numbers without decimals, and rounded to the nearest number.

I hope that helps.

Regards, Joakim

I
IrinaAuthor
December 30, 2024

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)?

J
JoakimK
December 30, 2024

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

I
IrinaAuthor
January 15, 2025

Dear colleagues,

Thank you! Yes, we need to correct also totals in order sum of rounded figures equals 1+1 =2 (not 3)

Terms & ConditionsAccessibility statement