I am trying to calculate a percentage using the numerator and denominator below.
Numerator: Amount for the specific month if the Amount is > $25, if not 0
Denominator: Sum the Amounts for all the months having Amount>$25. The only catch is Summing only the amounts that are >$25.
This will be the month level penetration percentage.
I have to calculate similar penetration for seasons and years.
Any help to restrict the denominator to use only >$25 amounts is appreciated.
Note that the Denominator doesn't sum any value that is not >$25.