
1. Re: Calculate the percentage by FIXED
Ken Flerlage Jan 12, 2019 11:24 AM (in response to Dinh Hoang)Could you provide a packaged workbook to give us an idea of what you've done so far?

2. Re: Calculate the percentage by FIXED
Paul Wachtler Jan 12, 2019 3:04 PM (in response to Dinh Hoang)Hi Dinh,
I think for your 'a' calculation you need to include the if statement inside of the count():
{FIXED [Subcategory], [Warranty staff]: COUNT (IF [Hour]> 0 and [Hour] <= 24 THEN [Hour] END)}
Best,
Paul

3. Re: Calculate the percentage by FIXED
Dinh Hoang Jan 12, 2019 5:25 PM (in response to Paul Wachtler) 
4. Re: Calculate the percentage by FIXED
Dinh Hoang Jan 12, 2019 6:29 PM (in response to Ken Flerlage)Ken Flerlage a écrit:
Could you provide a packaged workbook to give us an idea of what you've done so far?
Chào Ken!
Tôi rất xin lỗi
Đây rồi!
https://drive.google.com/file/d/1KFKRXzhesrIltGmFCTKeZb4k50bgb24/view?usp=sharing
Thanks

5. Re: Calculate the percentage by FIXED
Paul Wachtler Jan 12, 2019 6:29 PM (in response to Paul Wachtler)1 of 1 people found this helpfulHi Dinh,
Realized that you wanted to divide by the total count of hours too. It depends on what else you have on your worksheet. Count([Hours[) should work if you don't have anything else on the worksheet. If you do, {fixed : count([Hours])} should work but depends on if you have any filters. If you have filters, making them context filters will get them to be processed before the fixed LOD calculation.
Paul

6. Re: Calculate the percentage by FIXED
Paul Wachtler Jan 12, 2019 6:31 PM (in response to Dinh Hoang)1 of 1 people found this helpfulHi Dinh,
See my last reply. {fixed : count([Hours])} will work for calculating the total count of hours.
Paul

7. Re: Calculate the percentage by FIXED
Dinh Hoang Jan 13, 2019 4:10 AM (in response to Paul Wachtler)Hi PAUL!
Thanks so much!
Besides, I created calculation "Group time" to group hours: IF Hour >= 0 and Hour <=24 THEN "24h" ELSE 0 END
Similar "48h" and "72h"
{ FIXED [Moc Gio] : COUNT (IF [Hour]> 0 and [Hour] <= 24 THEN [Hour] END)}
Thanks!

8. Re: Calculate the percentage by FIXED
Dinh Hoang Jan 13, 2019 4:10 AM (in response to Paul Wachtler)Hi PAUL!
Thanks so much!
Besides, I created calculation "Group time" to group hours: IF Hour >= 0 and Hour <=24 THEN "24h" ELSE 0 END
Similar "48h" and "72h"
{ FIXED [Group time] : COUNT (IF [Hour]> 0 and [Hour] <= 24 THEN [Hour] END)}
Thanks!

9. Re: Calculate the percentage by FIXED
Paul Wachtler Jan 13, 2019 8:16 AM (in response to Dinh Hoang)You're welcome Dinh! Glad it worked out for you. Can you please mark my reply as helpful and correct to close out this thread? Thanks!