Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
can some one help similar in this excel file in qlikview?
thanks
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?
value should be 1.47%,after applied above syntax even getting all are null values.
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%')
will try and let u know..many thanks for your help.