Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've searched high and low in the documentation and can't find the proper format to exclude values from a chart expression....
I want the sum of a field but only if the value is greater than 6. Here is the expression I've used to get the value if it equals 6, but the <> or > doesn't work...
sum({$AgeMos={'6'}>}NumTickets)
Thank you,
Sarah
Probably this?
sum({<AgeMos={">6"}>} NumTickets)
Thank you, it worked like a charm.
Sarah