expression to pull avg acv greater than zero

[#1]

Hi guys,

fairly new to the qlik community trying to figure out an expression to pull our field 'acv extended price' when it's greater than zero. Any thoughts?

[sunny_talwar · Accepted solution]

May be this:

=Sum({<[acv extended price] = {'>0'}>}[acv extended price]) or

=Sum(If([acv extended price] > 0, [acv extended price], 0))

[#3]

thank you very much! Makes sense and worked great!

[sunny_talwar]

Awesome

I am glad I was able to help