Round Average Count Reference Line

[ydelreal]

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?

[vmoreno2605]

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!