hours percentage % calculation

[buzzy996]

hi,

can some one help similar in this excel file in qlikview?

thanks

[sunny_talwar]

What is the output for first row (Aaakanksha1?) It should be 1.4%, are you getting that or another number? From the screeenshot it seems you are getting all nulls?

[buzzy996]

value should be 1.47%,after applied above syntax even getting all are null values.

[sunny_talwar]

What about this:

=Num(((SubField(Actual, ':', 1) * 3600) + (SubField(Actual, ':', 2) * 60) + (SubField(Actual, ':', 3)))/

((SubField(Budget, ':', 1) * 3600) + (SubField(Budget, ':', 2) * 60) + (SubField(Budget, ':', 3))), '##.00%')

[buzzy996]

will try and let u know..many thanks for your help.