Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
CLM_UTIL_TGT - How this field is getting calculated?
its coming from an excel. I have just applied some logic to transpose the field