How to make this expression work?

[eduardoramiro]

Hi everyone, I'm new to Qlik and would like some help. I have this expression that checks if the result of a calculation is equal to or greater than 100 and if it is greater than 100 I should remove 0.01. It turns out that he never gets to take that 0.01 away and always presents me as if I had given 100, even if it's greater than 100.

= If ((Sum ([in_inf_hot_modificacao]) / count ([path]) * 100) + (Sum ([in_inf_cold_modificacao]) / count ([path]) * 100) + (Sum ([in_inf_frozen_modificacao]) / count ([ path]) * 100) = 100,
(Sum ([in_inf_frozen_modificacao]) / count ([path]) * 100),
If ((Sum ([in_inf_hot_modificacao]) / count ([path]) * 100) + (Sum ( [in_inf_cold_modificacao]) / count (path) * 100) + (Sum ([in_inf_frozen_modificacao]) / count ([path]) * 100)> 100,
(Sum ([in_inf_frozen_modificacao]) / count ([path]) * 100) - 0,01))

[stevejoyce]

shouldn't the subtraction be a decimal, not a comma?  - .01?

Or confirm this results in > 100 in your chart/object

(Sum ([in_inf_hot_modificacao]) / count ([path]) * 100)
+
(Sum ( [in_inf_cold_modificacao]) / count (path) * 100)
+
(Sum ([in_inf_frozen_modificacao]) / count ([path]) * 100)