Text box expression

[rtr13]

Hi All,

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:

=NUM(SUM({<[AvgDailyCensusLocation]={'XYZ'}>} sum(AvgDailyCensusCount)/Count(VisitDate)),'##,##0')

With sum(AvgDailyCensusCount)/Count(VisitDate) being the expression to define the average inpatient census. 

I appreciate any input!

Thanks,

Rose

[Anil_Babu_Samineni · Accepted solution]

Question is not clear? Perhaps this

=NUM(SUM({<[AvgDailyCensusLocation]={'XYZ'}>} Aggr(sum(AvgDailyCensusCount)/Count(VisitDate),Dim1)),'##,##0')