This content has been marked as final.
Show 4 replies

1. Re: help with COUNTD calc
Shinichiro Murakami Sep 9, 2016 6:15 PM (in response to Steve Gesuale)You need to simplify the root of the formula.
[countd]
countd(if [Indicator #] = "2_N" then [Country]end)
Thanks,
Shin

2. Re: help with COUNTD calc
Steve Gesuale Sep 12, 2016 10:10 AM (in response to Shinichiro Murakami)Hi Shin,
Thanks for the suggestion. I can't seem to get that to work for "2%" since it's a calculated field not an "Indicator #" in the data itself. I tried revising the formula you suggested, but still no luck.
Any other suggestions?
Thanks for the help!
Steve

counting countries.twbx 103.8 KB


3. Re: help with COUNTD calc
Shinichiro Murakami Sep 12, 2016 10:38 AM (in response to Steve Gesuale) 
4. Re: help with COUNTD calc
Steve Gesuale Sep 12, 2016 12:05 PM (in response to Shinichiro Murakami)Hi Shin,
OK  I get it now. I just need to create a discrete calc for each one. Thanks again!
Steve