Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi @Kylerose9 ,
try something like this:
median( { < yourField = {">0"} > } yourField)
or
median( { < yourField = {"=sum(yourField)>0"} > } yourField)
Thanks.
br
m