(Sub)Totals for column of only the values >0

[gembreda]

Hi all,

I would like to get some help on the following issue:

In one of our reports I used a formula to get the difference between column A and B (If( - > 0.019, - , null() ) ). In our report I want the total sum of each column. Qlikview gives us result 1 but we want result...

Could someone please help me solve our problem? We want totals for every Department and every Company as well.

Company	Department	Position	A	B	A-B (if >0)	B-A (if >0)
QT	East	Manager	1	1
		Advisor	4	2	2
		Consultant	3	2	1
		Assistant	2	4		2
Result 1	Total of East		10	9	1
Result 2	Total of East I would like to see		10	9	3	2

[gembreda · Accepted solution]

Thanks to your answers I was able to get the desired result. I used the expressions below:

Column A:          = SUM(num(round(Formatieplaats.Formatiegrootte/36,0.01),'#0,000'))

Column B:          = sum(num(round(aggr(num($(xBezetting)

Column - : =sum(if((num(round(num((Formatieplaats.Formatiegrootte)/36,'#0,00'),0.01)- (round(aggr(num($(xB...

Column - : =sum(if((num(round(num((Formatieplaats.Formatiegrootte)/36,'#0,00'),0.01)-(round(aggr(num($(xBezet...

-(num(round(num((Formatieplaats.Formatiegrootte)/36,'#0,00'),0.01)-(round(aggr(num($(xBezetting)/36,'#0,00'),[Formatieplaats]),0.01)),'#0,00')),null()))