on 10-11-2016 8:01 PM
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?
Thanks in advanced.
Matthew.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
use this =Truncate((1400+1300)/1000;0)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.