8 Replies Latest reply: Jan 20, 2014 5:36 AM by Alessandro Saccone RSS

    Sum Total Conditional

      Hi,

       

      I am trying to write a formula to calculate Market Share:

       

      sum(if(Condition=1,Units))/sum(Total{<Condition={1},competitor>}Units)

       

      The first part of formula(Numerator) is working. However when i use total condition in next part(denominator) it fetches no result. How can i modify the same to apply both condition?

       

      Thanks.