Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Result of Interval is text and not number

Hello;

I am trying to get the average of month per contract.

This is the formula used:

num#((num#(round((num#(Interval([Contract End Date]-[Contract Start Date],'dd')/365)*12))))/Count (DISTINCT Contract))

Even using the num#, it never provided a number in the total of the expression.

What to do in this case?

Thanks

Kristel.

10 Replies
Not applicable
Author

Unfortunately this did not provide any result.

Not sure why???

Thanks for the effort