1 person found this helpful
The script itself doesn't have any errors in it. What do you mean by "it's not working"? Are you getting any error messages in the JS Console? Does it not produce the correct result?
Thank you for your time!
It does not produce the result I expected.
1 300,000X59% = 177,000
2 300,000X100% = 300,000
3 300,000X100% = 300,000
4 300,000X100% = 300,000
5 300,000X100% = 300,000
6 300,000X100% = 300,000
When I only had the first property in the query, it returned a result of 177,000 which is correct answer. When I added in the next 5 (as shown in my original question), I expected to get a result of 1,677,000. However, the field did not update. Is there a better way to write the script? Maybe like a weighted value like in Excel?
I'm still new at this and haven't used the debugger before. I had to activate it, but don't know if its telling me anything
Did you change the value of any of the fields after applying the new code? It won't "kick in" until you do...
Thank you for your help. I tried adding in each section of the query one at a time and it all worked, until I added in property #3. Not sure how to read the debugger, but it also pointed to #3. After close review, I found that I had a space in field name between Market and Value, which was different than the rest of the fields. Fixed that and it worked. What I learned is to used the debugger to guide me. thank you soooooo much!