Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
kusha_2007
Contributor III
Contributor III

Two different results of a same calculation

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. 

1 Reply
dplr-rn
Partner - Master III
Partner - Master III

there seems to be a missing (

see in red

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