Calculating percentage

[deepakqlikview_123]

Hi All,

I want to calculate percentage for employee absenteeism.

Can you please tell me what would be the different ways for achieving the same.

Thanks

[MK_QSL]

Can you please elaborate little more on your requirements?

[deepakqlikview_123]

There is employee absentee count for number of employee who are absent on particular day.

I need to show percentage count of absent employee for the same.

Thanks,

Deepak

[MK_QSL]

COUNT({<Flag = {'Absent'}>}Employee)/COUNT(Total {<Flag = {'Absent'}>}Employee)

or

COUNT({<Flag = {'Absent'}>}Employee)/COUNT(Total Employee)

is this what you are looking for?

[deepakqlikview_123]

Thanks manish

but how to format number in this case.

[MK_QSL · Accepted solution]

To format in %

In tables and charts you can use Number tab

In text object

NUM(YourExpression, '#,##0.00%')

or

NUM(YourExpression, '#,##0%')