Two different results of a same calculation

[kusha_2007]

Hello All ,

I have two  calculations and they are giving results . 

=if((Round($(eCLMutil),0.01))/CLM_UTIL_TGT) < 0.75, 1, 0)- The answer is 1 

=if((Round($(eCLMutil),0.01))/0.8 < 0.75, 1, 0) .The answer is 0 

The value of CLM_UTIL_TGT=0.8  . Why the  first expression is not evaluating correctly. Also the value of Round($(eCLMutil),0.01)=0.60. 

Thanks  & regards,

Kusha

[dplr-rn]

you seem to have duplicate posts
check answer in previous
https://community.qlik.com/t5/QlikView-App-Development/Two-different-results-of-a-same-calculation/m...

[shiveshsingh]

What is the value of 

Round($(eCLMutil),0.01)/CLM_UTIL_TGT

You are missing brackets while evaluating first expression.

[kusha_2007]

Hello,

Actually the one extra bracket is a typo, the value of the below expression is .75 but still not evaluating correctly

Thanks

Kusha

[dplr-rn]

Share the actual expression please

[kusha_2007]

The exact expression is as shown below:

=if((Round($(eCLMutil),0.01))/CLM_UTIL_TGT < 0.75, 1, 0)- The answer is 1 

Round($(eCLMutil),0.01)= 0.60

CLM_UTIL_TGT= 0.8

Thanks

[Vegar]

As earlier answered, it looks/sounds like some data missmatch. Check if you get some unexpected result by temporary adding these expressions to your chart.
Count(CLM_UTIL_TGT)
min(CLM_UTIL_TGT)
Max(CLM_UTIL_TGT)
NullCount(CLM_UTIL_TGT)
ONLY(CLM_UTIL_TGT)

[PrashantSangle]

how "CLM_UTIL_TGT" this field evaluating??
is there any possibility of duplication of same value in that field?
and avoid naked expression.
try with below

=if((Round($(eCLMutil),0.01))/Sum(distinct CLM_UTIL_TGT)) < 0.75, 1, 0)

[kusha_2007]

There is  no possibility of the field being getting duplicated . I tried with your proposed way . ...the result is still the same

[kusha_2007]

I tried ..it gives me the same result for  max , min etc but with count it just gives one count.