Calculations in a Text and Image Chart

[Anonymous]

When I use :

count({<STATUS={'CHK'}>}encID) / interval(sum({<STATUS={'CHK'}>}Minutes), 'h')

I get '40.51', when the correct result should be '1.69'.

If I do:

count({<STATUS={'CHK'}>}encID) &'/'& interval(sum({<STATUS={'CHK'}>}Minutes), 'h')

I get: '464/274' - which is the correct values.

How do I correct my code to get the desired '1.69'?

[Lisa_P]

I think it's due to the formatting of the hours.

What happens if you divide by 60 instead of the interval ?

[Anonymous]

I changed function to:

count({<STATUS={'CHK'}>}encounterID) / (sum({<STATUS={'CHK'}>}interval(endTime - startTime, 'hh:mm')*60*24)/60)

which solved my problem.