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

    help with COUNTD calc

    Steve Gesuale



      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).




      (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?