Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. 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