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
Hi Jon! Try something like this:
SUM(IIF([Period3]>0, 1, 0)) / SUM([Number of Records])
This looks at each record and gives it a value of 1 if Period3 is greater than 0. Then, it divides that by the total number of records in each cell.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.