pivot table not showing total

[harleen_singh]

Hello i have a data like this

ID	Amount in Euro	rate
1	1600	3
2	2500	4
3	2300	5

i am using this formulat to caculate

=sum(AMOUNTCUR)/Rate

it is showing the correct sum with the rate divided by this But its not showing the Total when i select partial sum??

what may be the problem??

thanks

Lavi

[Anonymous]

hi did u try

=sum(AMOUNTCUR / Rate )

[sivarajs]

Its giving actually, may be check in number format

Sivaraj S

[harleen_singh]

Sivaraj,

               i have checked it with number format but its the same.

alfasierra

I have already tried it with sum(AMOUNTCUR / Rate ) but it shows correct values and sum too but

for one column its showing wrong value. the value is double the amount should i get.

i don't know why

[sivarajs]

Can u attach sample

[harleen_singh]

Sivaraj,

               can you see the sample file? and see the top value of column Depreciation Euro . All values are divided except that top value. It should be divided by 2 in this case

(Select year 2010 and AssetID FA00000010)

thanks

[Anonymous]

hi

try this

=if(TRANSTYPE=3 or TRANSTYPE=4,sum(AMOUNTCUR)/Rate)

[sivarajs]

Hi Lavi,

You meant to say that for asset other than FA00000010 you are not getting Depreciation Euro

am i right??

Sivaraj S

[harleen_singh]

@sivaraj,

                         no for the asset FA00000010 i am getting all the values of Depreciation Euro correctly except the one value at the top. (only top one value of  Depreciation Euro has problem

thanks

Lavi

[sivarajs]

Hi lavi,

Change your expression like

=sum(if(TRANSTYPE=3 or TRANSTYPE=4 ,(AMOUNTCUR)))/Rate

See the attached file