5 Replies Latest reply: Oct 20, 2016 1:00 PM by Nina Iren Jensen RSS

    Dividing count with sum?

    Nina Iren Jensen

      Hi,

       

      I have a table that lets say shows salesmen, month, sales and reasons for sale. If sale has happened it is stated with 1 - if not it says 0.

      Reasons are counted as these are stated with text. In the last colum I want to show the percentage of sales by dividing with reason, but I can't get this working. Either the result is 0%, 100% or even higher

       

      In the Sales dimension there is a expression calculating sales for the selected month;

      Sum({1<sales ={"1"},[Month]=p([Month])>}sales)

       

      In the Reason dimension there is a expression counting reasons

      Count(reasons)

       

      SalesmenMonthSalesReasonsPercentage
      JohnJAN200599,97%
      DaveJAN5050100,00%
      MaryJAN1001099,90%
      KateJAN1502099,86%