1 Reply Latest reply on Oct 5, 2016 9:32 AM by David Li

    Find % of Total for a Given Condition

    jon rios

      I have a measure that has either positive or negative numbers.

      I want to find the % that are positive within this measure.  My formula doesnt return what I need.

       

      IF SUM([Period3]) > 0 then

      (COUNT([Period3])/SUM([Period3])) END

       

      • Period3 is name of measure.
      • ei.  there are 500 values, 275 are positive, > 0. % Positive is .55