Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

agdgn123
New Contributor III

How to convert duration format to decimal format so that calculation result makes sense?

I want to multiply the monthly hours and the cost per hour below to get the total monthly cost.

The current calculation result does not make sense as you can see....the total cost column does not equal (cost per hour) *(monthly hours).

The monthly hours are in a duration timestamp format. i am suspecting that might be the reason. How do I convert them into decimal format ? hopefully that would solve my calculation problem.

My expressions:

Monthly hours: Sum(ServiceDuration)*4.34

Cost per hour:  sum(SalaryAverageHourlyRateScript)

Total Cost: Sum(ServiceDuration)*4.34 * sum(SalaryAverageHourlyRateScript)

1 Solution

Accepted Solutions
lironbaram
Honored Contributor II

Re: How to convert duration format to decimal format so that calculation result makes sense?

hi

just multiply the formula in 24

Sum(ServiceDuration)*4.34 * sum(SalaryAverageHourlyRateScript)*24

2 Replies
lironbaram
Honored Contributor II

Re: How to convert duration format to decimal format so that calculation result makes sense?

hi

just multiply the formula in 24

Sum(ServiceDuration)*4.34 * sum(SalaryAverageHourlyRateScript)*24

Highlighted
agdgn123
New Contributor III

Re: How to convert duration format to decimal format so that calculation result makes sense?

Thanks Liron! Feeling pretty stupid right now .

Community Browser