Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
glcordell
Contributor II
Contributor II

Calculate average of differences

I have a column of data called [Staff Timesheet Hours from Microix.Billed Hours]. I am calculating the difference from one row to the next with the following expression:

FABS(([Staff Timesheet Hours from Microix.Billed Hours])-Above([Staff Timesheet Hours from Microix.Billed Hours]))

This works correctly. Now I want to calculate the average of the differences (the average of the expression).

Any help would be appreciated. Thanks in advance.

Labels (1)
0 Replies