Latest Contributions by JoannaHahn

Thank you! ... View more

Yes that is the step I missed. How do I check the field types of my feature layer after it's created? ... View more

Yes, the numeric data in that column was appearing. And the other columns were fine. I bet you're right. I did updated the data and that seemed to fix it. But in the future how do you control the field type after the fact? ... View more

I don't. Would love to learn! ... View more

I fixed it! iif(isempty($feature["Arsenic_ug_L_"]),"",iif($feature["Arsenic_Function"]<$feature["Arsenic_MCL"],$feature["Arsenic_ug_L_"] + " ug/L","")) Since I gave it a direction if a field was below another field, it saw null as below that field and therefore reported a null with the unit of measure.  Thanks for your help!! ... View more

I did try that and same result. How can I learn more about your other approach? I could go back to my raw data and just add the unit of measure in the field but I don't want to give up. I don't see why I shouldn't be able to get something to work here.  ... View more

Thanks Xander! Actually can I back up a few steps? I have three expressions: 1. If the value is less than a threshold: {expression/expr1}= iif($feature["Arsenic_Function"]<$feature["Arsenic_MCL"],concatenate([$feature["Arsenic_ug_L_"], "ug/L"]," "),"") 2. If the value is greater than or equal to a threshold: {expression/expr0}= iif($feature["Arsenic_Function"]>=$feature["Arsenic_MCL"],concatenate([$feature["Arsenic_ug_L_"],"ug/L"]," "),"") 3. If there is no value:  {expression/expr2} = iif(isempty($feature["Arsenic_ug_L_"]),"","Arsenic:") And I've configured my pop up as follows: Here are my results: Good: Good: Bad: Since the problem example is in orange, I'm assuming I have done something wrong with my expression/expr1 = iif($feature["Arsenic_Function"]<$feature["Arsenic_MCL"],concatenate([$feature["Arsenic_ug_L_"], "ug/L"]," "),""). It's not showing the Arsenic title that is expressed in the isempty expression which is good, but it's holding on to that concatenate field regardless if the $feature["Arsenic_ug_L_"] is null. Thank you for your help! ... View more

Kelly this article was so helpful. I'm trying to incorporate a concatenate expression into the iif statement so I can include a unit of measure on the field to display if the first statement is true. But the result is the unit of measure is present in my pop up regardless if the field is empty in my other expression using isempty. Any ideas what I'm doing wrong? Here is my expression, it works as you described if I don't use concatenate. But I don't see why I shouldn't be able to. iif($feature["Arsenic_Function"]>=$feature["Arsenic_MCL"],concatenate([$feature["Arsenic_ug_L_"], "ug/L"], " "), "") Thank you! ... View more