Total sum

[rolandg1881]

Hi!

I have a problem and i hope somebody can  help me.

I have the following formular in my Qlikview Pivot Table

sum(ZBU_Soll_Zeit)/(count({<[ZBU_Buchungsart]={'Normalbuchung'}>}[ZBU_BeginnBuchungsdatum]))

If i use sum(ZBU_Soll_Zeit) i got the total sum in the last row! Thats perfect!

But with the formula below there is no total sum. 

How can i resolve this problem? Is it possible to make a total sum for:

sum(ZBU_Soll_Zeit)/(count({<[ZBU_Buchungsart]={'Normalbuchung'}>}[ZBU_BeginnBuchungsdatum]))

Thank you for your help!

Kind regards 

Roland

[rubenmarin]

Hi, I don't see why it shouldn't work. If you set and expression with count({<[ZBU_Buchungsart]={'Normalbuchung'}>}[ZBU_BeginnBuchungsdatum]) works?

Double check field names and values, in particular upper/lower case of 'Normalbuchung'.

Also you can select 'Normalbuchung' on [ZBU_Buchungsart] field to confirm that there is data for that filter.