Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am creating a line chart and in one of my expressions (Orders) I am trying to sum up the orders but when I did
=Sum(Orders) I noticed that there is a spike in the numbers. I am wanting to exclude all the numbers in Orders that caused the spike and not used them in this line. So I tried to do something like this
=if(Orders <5000,sum(Orders)) but my line just went away then.
Is there anything I can do to sum up the orders but keep anything over 5000 out?