4 Replies Latest reply on Sep 12, 2016 12:05 PM by Steve Gesuale

    help with COUNTD calc

    Steve Gesuale

      Hi,

       

      I’m having trouble with a calculated field. I want the field to count the number of countries that appear in the bar chart at right (those who have values for a different calculated field). But instead, my failed attempt is returning the total number of countries in the data (17 instead of 6).

       

      Capture.PNG

       

      (You can ignore the 139% for Mali - a separate issue )

       

      I used this calc thinking it would exclude those countries without values, but no luck…

       

      { FIXED [Country] :  COUNTD(IF [Value] >= 0 THEN [Number of Records] ELSE NULL END)}

       

      Does anyone have some advice on fixing that calc to return 6 instead of 17?

       

      Thanks.

      Steve