Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can someone explain how my expression total can differ from the Sum total, as the expression is a Sum([value])
Thanks.
The relationship between N-2 and Quarter has to cross the PO table. Is there definitely an association for very record? I think you may need to work on your data model a bit first. Which table is the fact table? Looks like the PO table is, as there is a date, but Value is on tab1-1. If you improve the model you may find the results tally with what's expected.
Hi,
Suppose you have value
Item A,B,C
Value =10,20,30
Sum(Total Value ) = 60 It will give 60 value
but
Sum( Val ) gives 10 , 20 ,30 for
A,B, C
See attachment file
Let me know
Rgds
Anand
How does the expression total behave then? If the expression is Sum([value])
I am just interested to know how does this differ from the sum total?
Thanks
i have seen expression total is sometimetimes not showing exact value.
but if u cantake sum of total row then it will show sum of all row.
as per me we ca trust on sum of rows
thanks
Sunil chauhan
Hi,
Expression total behaves like it id for your expresson only.
If you simple Sum( value ) it gives 60 but if you take any dimension like item
For
A = 10
B = 20
C = 30
It give Sum( value ) according to dimension
But Sum(Total value) gives only all sum value it is use full for show percentage values.
See attached sample
Rgds
Anand
Hi,
My problem is with my pivot table. It shows when i had expressio total in level 1 58, 000e,
but when you expanded it and sent it to excel the total equals 62,000e??
Now ive change the expression total mode to Sum of rows, and now it displays the totals correctly.
Is it a glitch, or?
Sorry, i cant post the file as it's our company finance.
Hi,
Yes right it is the difference when you use it on the pivot table or straight table where it Count, Sum, Average your rows according to your data.
If you want to use Total sum so for this use variables store Sum(Total value) there and then use it on charts where ever you want.
Let me know
Rgds
Anand
It's not a bug. Expression total evaluates the expression over the whole data set (subject to selections) which may or may not equal the sum of the rows.
For example:
SaleID,Item,SaleValue
1,1,10
2,1,50
3,2,30
4,1,20
5,2,100
6,3,42
7,3,60
8,2,25
9,1,60
10,3,30
Now, say you have a chart with Item as the dimension and Avg(SaleValue) as the expression. You will have:
Item Average
1 35
2 51.67
3 44
The average of all sales calculated by Avg(SaleValue) will be 42.7 and this is what is shown by Expression Total.
However the Sum of Rows will be 130.67.
The Average of Rows will be 43.56 - different to Avg(SaleValue).
Hope that makes it clearer.
Jason
i have seen expression total is sometimetimes not showing exact value.
but if u cantake sum of total row then it will show sum of all row.
we can trust on sum of rows
thanks
Sunil chauhan
Hi,
Thanks for the explanation, however, i went into the raw data and the total for Q1 is the total displayed in the expression total.
So now the total sum is incorrect?? how did that happen? dont even understand how its possible.