Networkdays with if statements

[#1]

Hi All,

I need to  work out the average number of days between two dates using dimensions as to filter out irrelevant results.

could anyone provide help with this formula?

[sunny_talwar]

Would you be able to share some sample data and what is the expected output from that sample?

[#3]

Hi Sunny,

I cant show you the data but I will show you the formula:

=networkdays([Schedule for Interview],[Interview Arranged])

This is whats in their currently, however I need to work out the average which the standard formula doesn't seem to work?

and then I want to add in an If statement to only include [Interview Arranged] with values in.

Hope this makes sense and any help would be greatly appreciated.

Kind regards

[sunny_talwar]

This is whats in their currently, however I need to work out the average which the standard formula doesn't seem to work?

and then I want to add in an If statement to only include [Interview Arranged] with values in.

I am still not sure what average you wish to calculate here and what is the if statement here?

QlikCommunity Tip: How to get answers to your post?