topic Re: how to calculate percentage in App Development

how to calculate percentage

Fia_Fiia — Sat, 26 Oct 2019 06:53:06 GMT

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])

Re: how to calculate percentage

Vegar — Sat, 26 Oct 2019 08:01:42 GMT

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])

Re: how to calculate percentage

Fia_Fiia — Sat, 26 Oct 2019 09:40:21 GMT

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

Re: how to calculate percentage

Vegar — Sat, 26 Oct 2019 18:40:18 GMT

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])