8 Replies Latest reply on Jun 1, 2016 8:59 AM by matt.gazda

    How to Subtract State - 1

    matt.gazda

      I have a data set with states in the USA and I want the whole of the US to be highlighted. However, not all states have data. So I went into my data set and listed each state again so the map would populate. So my total states are currently showing one too many for each state. To fix this, my calculation is "[States] - 1".

       

      The equations says it is valid but when I drop it into the color detail on my geo map, the map only shows one color for all states and no detail on the count.

       

      Any help would be appreciated.

       

      Message was edited by: Matt Gazda Added the twbx. Currently it shows one value too many for each state. I need each "Number of Records" to be decreased by 1 hopefully without changing my original workbook.