Calculate Average head count Q1 to Average head count Q4

[Anonymous]

  Hi All,

Calculate Average head count Q1 to Average head count Q4

EX: Average head count Q1=6807  

Average head count Q4=7432

Variance=7432-6807=625

Variance % = (625/6807)*100= 9.18

  Formula: (Q4-Q1/Q1)*100

I want to show this value in a test Object.

Thanks,

Krishna

[sunny_talwar · Accepted solution]

May be this?

=Num(Round(Avg({<[Fiscal Quarter] = {'Q4'}>} Aggr(Count({<[Fiscal Quarter] = {'Q4'}>} DISTINCT [Emp. Id]), Month)))/Round(Avg({<[Fiscal Quarter] = {'Q1'}>} Aggr(Count({<[Fiscal Quarter] = {'Q1'}>} DISTINCT [Emp. Id]), Month))) - 1, '##.##%')

[Anonymous]

Wow Sunny, You great.

Thanks,

Krishna