Multiply amount with minutes in pivot

[bartvanwetten]

Dear all,

Can someone help me out on this one:

How can I get the 'amountperhour' in the last column. It should be 760/345*60=132.17 for the second row in the pivot above.

QlikView document is attached.

Many thx!

Bart

[sunny_talwar · Accepted solution]

May be this

Amount/Num#(MinutesSpend)*60

[bartvanwetten]

Hi Sunny,

and again, you've made my day!

Bart