https://community.qlik.com/t5/QlikView/Text-box-expression/m-p/1613354#M734753 <P>Question is not clear? Perhaps this</P><P><STRONG>=NUM(SUM({&lt;[AvgDailyCensusLocation]={'XYZ'}&gt;} Aggr(sum(AvgDailyCensusCount)/Count(VisitDate),Dim1)),'##,##0')</STRONG></P> Fri, 16 Aug 2019 15:23:54 GMT Anil_Babu_Samineni 2019-08-16T15:23:54Z https://community.qlik.com/t5/QlikView/Text-box-expression/m-p/1613352#M734752 <P>Hi All,</P><P>I am currently trying to come up with an expression to create two call out boxes each that contains the Average Inpatient Census for the locations. This is the expression I am currently trying to use:</P><P>=NUM(SUM({&lt;[AvgDailyCensusLocation]={'XYZ'}&gt;} sum(AvgDailyCensusCount)/Count(VisitDate)),'##,##0')</P><P>With sum(AvgDailyCensusCount)/Count(VisitDate) being the expression to define the average inpatient census.&nbsp;</P><P>I appreciate any input!</P><P>Thanks,</P><P>Rose</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Text-box-expression/m-p/1613352#M734752 rtr13 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Text-box-expression/m-p/1613354#M734753 <P>Question is not clear? Perhaps this</P><P><STRONG>=NUM(SUM({&lt;[AvgDailyCensusLocation]={'XYZ'}&gt;} Aggr(sum(AvgDailyCensusCount)/Count(VisitDate),Dim1)),'##,##0')</STRONG></P> Fri, 16 Aug 2019 15:23:54 GMT https://community.qlik.com/t5/QlikView/Text-box-expression/m-p/1613354#M734753 Anil_Babu_Samineni 2019-08-16T15:23:54Z