This content has been marked as final.
Show 6 replies

1. Re: Percentage of aggregated data, exclude from denominator if numerator is null
Hari Ankem Oct 3, 2018 4:12 PM (in response to Amanda Bruesch)
Anonymized Antibiogram Data.twbx 87.7 KB


2. Re: Percentage of aggregated data, exclude from denominator if numerator is null
Shinichiro Murakami Oct 3, 2018 4:14 PM (in response to Amanda Bruesch)1 of 1 people found this helpful 
3. Re: Percentage of aggregated data, exclude from denominator if numerator is null
Amanda Bruesch Oct 3, 2018 6:43 PM (in response to Hari Ankem)Thank you so much  you solved this so quickly! I really appreciate your help. You used a simple, elegant calculation to make this work. I don't know why it was so elusive to me. Thanks again!

4. Re: Percentage of aggregated data, exclude from denominator if numerator is null
Amanda Bruesch Oct 3, 2018 6:45 PM (in response to Shinichiro Murakami)Thank you so much. I appreciate your help. You used a little different approach, more like what I was trying to do  but I was focusing on the numerator, and should have used my logic toward the denominator. Thank you!

5. Re: Percentage of aggregated data, exclude from denominator if numerator is null
Shinichiro Murakami Oct 3, 2018 6:50 PM (in response to Amanda Bruesch)You are very welcome.
Thanks,
Shin

6. Re: Percentage of aggregated data, exclude from denominator if numerator is null
Hari Ankem Oct 3, 2018 7:18 PM (in response to Amanda Bruesch)You are welcome Amanda.