Hi,
I want to find out the test availability
formula level1 %=(total available hours per month for level1 - sum(demo) / total available hours per month for level1
I have used expression:
if([Level]<>'Level 2',((24*Count(Month)*(193))-(sum([demo])))/(24*Count(Month)*(193)))
and to find out the Level2 formula
formula level2 %=(total available hours per month for level2 - sum(demo) / total available hours per month for level2
total available hours per month for level2 calculations
=16hrs
*
=31days(Month) - [Is Week End]<>1
*
=611 Applications
Note: Except Sundays only 6days in a week so I used a flag [Is Week End]<>1
if([Is Week End]<>1,((16*Count(Month)*(611))-(sum([demo])))/(16*Count(Month)*(611)))
So after using the above expression when I am selecting level 1 or level2 in separate check box my pivot table is not getting displayed and test tube chart is not getting displayed,
So can you kindly help me
| Level | Demo |
| Level1 | 0 |
| Level1 | 0.0333333 |
| Level1 | 0.05 |
| Level1 | 0.0666667 |
| Level1 | 0.0833333 |
| Level1 | 0.1 |
| Level1 | 0.1166667 |
| Level1 | 0.1333333 |
| Level1 | 0.15 |
| Level1 | 0.2333333 |
| Level2 | 85.383333 |
| Level2 | 85.633333 |
| Level2 | 87.816667 |
| Level2 | 88.583333 |
| Level2 | 88.883333 |
| Level2 | 89.433333 |
| Level2 | 89.983333 |
| Level2 | 93.05 |
| Level2 | 94.833333 |
| Level2 | 95.616667 |
