1 Reply Latest reply on Apr 11, 2012 11:11 AM by Alex Kerin

    Dividing Integer values by string values

      I have two fields I am trying to combine in a calculated field.


      1.) Qty

      2.) Selling Stores


      Qty is straight forward, its a measure that returns the quantity sold per item number.


      Selling stores is a little different.  It is a COUNTD of a dimension titled CustID.  This returns to me the number of unique stores that have had sales.


      When I try to do the formula


      Qty/SellingStores I get an error that says "Can't Divide Integer Value by String Value"


      Does anyone know a formula where i can make the selling stores an actual number instead of a string?  OR - does anyone know of a better way to get the calc?