Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Partner
Partner

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
New Contributor III

Re: Round Average Count Reference Line

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!