Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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. 

 

Thanks  & regards,

Kusha

12 Replies
PrashantSangle

share screen shot of what you tried???
Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
shiveshsingh
Master
Master

CLM_UTIL_TGT - How this field is getting calculated?

kusha_2007
Contributor III
Contributor III
Author

its coming from an excel. I have just applied some logic to transpose the field