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

Find % of Total for a Given Condition

jon rios Oct 5, 2016 9:12 AM

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

1. Re: Find % of Total for a Given Condition

David Li Oct 5, 2016 9:32 AM (in response to jon rios)

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.
Like Show 0 Likes(0)

Actions

Tableau Community