Total in Pivot Table

[kprotrka]

I have a problem with the summing in the pivot table. For example i have one column in the table and it showing total as 3,51. When i change it to sum----option where you can choose which function will you use...it is correct(with sum function). In the pivot table it just showing 3,51 and i want to have the number from the column 2(in Screenshot).

[Or]

Move your if() statement inside the sum, rather than vice versa.

[kprotrka]

not working...this is my formula...

if(status<>'COMPLETED' OR status<>'DEFERRED', sum(distinct(Zeitaufwand_Grouped/Stunden_Grouped))/count(distinct Mitarbeiter_ID))