Here is the field calculator formula I'm trying to use. It's an Excel formula I've copied over and replaced referenced cells with columns in my table.
100-(15*(((0.445*((0.8*[SUM_t2])^1.15))+ (0.13 * ((0.8*[SUM_t1])^1.35)))^0.5))
Solved! Go to Solution.
^ in python is **, meaning to the power of, hence **0.5 is the sqrt
^ in python is **, meaning to the power of, hence **0.5 is the sqrt
That did the trick. Thanks!
Hi Anthony Von Moos,
Not that I have ever come across, but I think what you could do is use either VBScript or Python and translate your Excel formula to python and use that in the field calculator to calculate the values.
Hope this helps.
Cheers,
Manish
If this answer solved your question or if you found it helpful please mark it accordingly to help others who have the same question.