how to calculate percentage

[Fia_Fiia]

Hi,

Please help me, I want calculate percentage but this formula doesn't work, the percentage not 100 %

COUNT({<[EmpStatusByMonth] = {[Active]}>} distinct [Emp No] )/Count({<[EmpStatusByMonth] = {[Active]}>} TOTAL<[Emp No],PT,[Fto Name],Month>distinct [Emp No])

[Vegar]

It could be the EmpStatusByMonth modifier that is wrong. Try this:

COUNT({<[EmpStatusByMonth] = {'Active'}>} distinct [Emp No] )/Count({<[EmpStatusByMonth] = {'Active'}>} TOTAL<[Emp No],PT,[Fto Name],Month>distinct [Emp No])

[Fia_Fiia]

I tried it but it still doesn't work ....

[Vegar]

Do you have control over your TOTAL <...> setup. Try removing the <...> and add one dimension at the time.

COUNT({<[EmpStatusByMonth] = {'Active'}>} distinct [Emp No] )/Count({<[EmpStatusByMonth] = {'Active'}>} TOTAL<[Emp No],PT,[Fto Name],Month>distinct [Emp No])