Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ydelreal
Partner - Contributor
Partner - Contributor

Round Average Count Reference Line

Hi, 

I currently have this formula;

=Avg({1} Aggr(Count({1} ID), [Month]))

But I want the result average to be rounded to a whole number. How can I achieve this?

1 Reply
vmoreno2605
Creator
Creator

You can use the function Round()

https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Gene...

I think this is what you need
=Round(Avg({1} Aggr(Count({1} ID), [Month])))

I hope it helps!