Expression in %

[amber2000]

Hi all,

I want to calculate the % of [#Time Worked] per [Jobcode Flag].

There are only 2 [Jobcode Flag] values: Productive and Non Productive

Jobcode Flag
Productive
Non Productive

When nothing is selected then the values for expression [#Time Worked] are displayed correctly for both [Jobcode Flag] fields.

Butnot for expression [=vTimeWorked], the total TimeWorked is showed there instead of x... time Productive and x... Time Non Productive.

Total Time Worked
Jobcode Flag	#TimeWorked	=vTimeWorked
	100%	7:42:37
Productive	47,08%	7:42:37
Non Productive	52,92%	7:42:37

This is the result I would like to see:  

Total Time Worked
Jobcode Flag	#TimeWorked	=vTimeWorked
	100%	7:42:37
Productive	47,08%	3:37:47
Non Productive	52,92%	4:04:50

When I select a [Jobcode Flag] Productive then the value of the expression #TimeWorked becomes 100% instead of 47,08%

If  I select Non Productive the same happens.

I have the same problem for this Table with expression %PP:

If I make a selection 'Productive' the value should be 47,08%, Non Productive should be 52,92% and if no selection is made then the value should be 100%

Assignments by employee
Employee Badge	#Time Worked	#Colli	#Assignments	Average Assignments	Productivity	Target	Percentage	%PP
5139	7:42:37	539	22	24,5	69,91	137,2	50,95%	-

Can anyone help me with this problem please? I'll attach a copy of the qvw to make it easy to so see what is going on.

Kind regards,

Monique

[Anil_Babu_Samineni]

For first output you may need this?

=sum({$<[Jobcode]={"*"}-{"ILUNP"}>} if([Aisle Zone]='FORK' and [Jobcode]<>'IINCH' and [Jobcode]<>'DPURP' and [Action Code] <> 'PM' ,[Assignment Replenish Time], [Assignment Time Worked]-[Assignment Beginday Difference]))

And second one are you talking about %PP?? If so, What value you are expecting to see

[amber2000]

If I make a selection 'Productive' the value should be 47,08%, Non Productive should be 52,92% and if no selection is made then the value should be 100%

[sunny_talwar]

May be like attached

[aarkay29]

PFA

Updated with PP%

Thanks,

Aar

[amber2000]

Thanks Sunny,

Do you also Know how to handle the expression that's needed for %PP please?

Monique

[sunny_talwar]

Check now

[amber2000]

Thanks Sunny,

This is what I wanted, and actually this isn't so difficult.

Kind regards,

Monique

[amber2000]

Thanks Aar,

Your solution is the same as Sunny's.

I would like to thank you all for helping me.

You guys are great

Monique

[amber2000]

Sunny,

I'm sorry but with one record everything looked good.

But there is still something not quit wright, I've added a few more records to see the difference.

If I select nothing so the %PP should give me 100% per record. (It's not doing that, the 100% is splitted into 5 values, 1 value per record)

Employee Badge	#Time Worked	#Colli	#Assignments	Average Assignments	Productivity	Target	Percentage	%PP
2635	7:47:00	463	11	42,09	59,49	185,20	32,12%	21,66%
4103	7:45:26	392	14	28,00	50,53	148,40	34,05%	21,59%
4708	5:09:36	834	19	43,89	161,63	193,14	83,69%	14,36%
5139	7:42:37	539	22	24,50	69,91	137,20	50,95%	21,45%
9124	7:31:35	1.601	44	36,39	212,72	163,74	129,91%	20,94%

When I select Productive then the % changes to less:         

Employee Badge	#Time Worked	#Colli	#Assignments	Average Assignments	Productivity	Target	Percentage	%PP
2635	2:08:15	463	8	57,88	216,61	214,14	101,15%	5,95%
4103	2:09:03	392	11	35,64	182,25	160,36	113,65%	5,98%
4708	5:02:11	834	18	46,33	165,59	194,60	85,09%	14,01%
5139	3:37:47	539	19	28,37	148,50	147,52	100,66%	10,10%
9124	6:51:30	1.601	41	39,05	233,44	175,72	132,85%	19,08%

For EmployeeBadge the Productive %PP should be 27,46% and whatever the selection I make it's not showing the correct result.

In the Main tab the result of %PP is also different, it should show the same result (here the dimension is Department instead of EmployeeBadge

Do you know what's wrong?

Monique