### Summation of rounding figure in webi

Hello Hi,

I have a question about webi summation when the figures are rounded in thousand.

Here is a basic example...

in Jan 2016, the sales figure is \$1400 and in Feb 2016, the sales figure is \$1300. I need to display them in thousand and get the total amount.

What i am expecting the output is like this after rounding them in thousand... in both Jan 2016 and Feb 2016, they both are showing \$1 and the total will be \$2

The result of each month is correct after i use a simple formula to divide the sales figure by 1000 and change the number format not to show decimal places. However, the summation amount shows \$3 instead of \$2. I believe it is because webi does this (1400+1300)/1000.

So my question is, how can i force webi to sum the rounded figure instead of just rounded the summation of original amount?

Matthew.

10|10000 characters needed characters exceeded

• Oct 18, 2016 at 09:07 AM

use this =Truncate((1400+1300)/1000;0)

10|10000 characters needed characters exceeded
• Former Member
Oct 18, 2016 at 09:17 AM

Hello Matthew,

You can use below formula for SalesFigure as

```[NewSalesFigure]=[SalesFigure]-Mod([SalesFigure];1000)
```

So with above code you will get [NewSalesFigure] for 1300 as 1 and for 1400 as 1 now just take the sum of it this will display the total as 2.

Regards

Niraj