13 Replies Latest reply on Sep 29, 2016 1:48 PM by heather.vogt

    Calculation error?

    heather.vogt

      Hello! Can someone help me figure out what's wrong with my variable-sized bin?

       

      I am trying to bin regions of the world into sales categories--High, Medium and Low. The High bin will bin regions with >=$500,000 in sales. Medium is for sales between $499,999-250,000 and, finally, Low is for anything <=$249,999.

       

      I used the calculation editor to create a Region Bins variable-sized bin, but when I go to use it, only the Medium measure applies to the viz. I've gone through the calculation to see if I missed anything but nothing catches my eye. Any ideas?

       

      I attached the workbook. The sheet in question is 15-16 Sales by Regions.