Use devide operator between set analysis

[#1]

Hi.

I'm trying to use "/" between to set analysis calculations but it doesent work, only get 0. But if i use "+","-" or "*" it works fine. It looks like this:

sum({$<Color={'Blue'},Length-={'UNKNOWN'}>} Duration_s)/3600 / sum({$<Length-={'UNKNOWN'}>} Duration_s)/3600

Any suggestions

[swuehl]

What two values do you get for the two single sum() expressions?

Are you displaying the result with an appropriate amount of decimal places?

[bbi_mba_76]

Hi,

maybe there are missing brackets:

sum({$<Color={'Blue'},Length-={'UNKNOWN'}>} Duration_s)/3600 /

(sum({$<Length-={'UNKNOWN'}>} Duration_s)/3600 )

and if so you could avoid the /3600

sum({$<Color={'Blue'},Length-={'UNKNOWN'}>} Duration_s) /

(sum({$<Length-={'UNKNOWN'}>} Duration_s) )

[kaushalview · Accepted solution]

Hi,

Use proper Backet Like ().

(sum({$<Color={'Blue'},Length-={'UNKNOWN'}>} Duration_s)/3600)

/

(sum({$<Length-={'UNKNOWN'}>} Duration_s)/3600)

Regards

Kaushal Mehta

[#5]

Yes, I think rather that the problem is about how to displaying the numbers.

The values for one month is 3615/232= 15,58189655172414

[swuehl]

So

sum({$<Color={'Blue'},Length-={'UNKNOWN'}>} Duration_s)

is larger than

sum({$<Length-={'UNKNOWN'}>} Duration_s)

(even there is an additional filter applied)?

Or are you actually calculating 232 / 3615 = 0.064

and displaying only integer / rounded values?