Median Case When

[Kylerose9]

I'm trying to have my table calculate the median order value, but only when orders are greater than £0. How would I set up my formula to do this?

[mato32188]

Hi @Kylerose9 ,

try something like this:

median( { < yourField = {">0"} > } yourField)

or

median( { < yourField = {"=sum(yourField)>0"} > } yourField)

Thanks.

br

m