Pivot table Total showing Wrong?

[#1]

Hi All,

Please find below image.

Here i am using Pivot table with full expand. when select date wise parital sum at the bottom is not coming gives Null----why?

2).When i selected process wise(HCFA,UB) partial sum is also not coming correct value --------why?

Can any one help on this???????????????

[alexandros17]

What is your expression?

Have you aggr instruction?

[giakoum]

it depends on how you syntax your expressions. Please attach a sample app. Does sum of rows work?

[#4]

Hi

I used this expression :

if((Below(sum(TotalDays)))+sum(TotalWorked)-sum(TotalDays)<0,0,

        (Below(sum(TotalDays)))+sum(TotalWorked)-sum(TotalDays))

Below() for i need next day result that's y i used.

[giakoum]

QlikView is trying to use the same expression to calculate the total, but bellow cannot work in total. You most likely need to aggr. Did you try sum of rows?