Expression total vs Sum total

[#1]

Hi,

Can someone explain how my expression total can differ from the Sum total, as the expression is a Sum([value])

Thanks.

[its_anandrjs]

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

[#3]

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

[SunilChauhan]

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

[its_anandrjs]

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

[#6]

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.

[its_anandrjs]

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

[Jason_Michaelides]

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

[SunilChauhan]

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

[#10]

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.