I have a field that I'm calculating based off inputs from other fields. If a tree is dead, it gets a score of 8. If a tree isn't dead, then the score is calculated by adding two other values together. I have written:
if(selected(${Dead_Tree},'yes'),8,''),if(selected(${Dead_Tree},'no'),'int(${Highest_Potential})+int(${Total_Failure})','')
However I keep getting "bad node" errors. How do I write the proper expression?
Solved! Go to Solution.
Ok after more trial and error, I seem to have gotten the result I was looking for with the following forumla:
if(selected(${Dead_Tree},'yes'),8,((${Highest_Pot_Score})+(${Total_Fail_Potent})))
Ok after more trial and error, I seem to have gotten the result I was looking for with the following forumla:
if(selected(${Dead_Tree},'yes'),8,((${Highest_Pot_Score})+(${Total_Fail_Potent})))