Conditional Calculations Logic?

466
1
Jump to solution
12-13-2018 09:30 AM
deleted-user-jxpbpbjlZInj
Occasional Contributor

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?

1 Solution

Accepted Solutions
deleted-user-jxpbpbjlZInj
Occasional Contributor

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})))

View solution in original post

0 Kudos
1 Reply
deleted-user-jxpbpbjlZInj
Occasional Contributor

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})))

0 Kudos