Hi,
I'm trying to use a conditional statement to filter tickets by the value of a numeric custom field. The field reports a file size in bytes and I'm trying to show only tickets where bytes is greater than a certain number. My conditional statement is as follows:
IF (SUM(#Total submission size (in bytes)) > 2000000000 ) THEN [Ticket ID] ENDIF
The problem is that I am still seeing tickets where the value is less than the one in the statement. For example, I am seeing a ticket where the value is 558083849, which is clearly less than 2000000000.
Could anyone help with this? Have I formatted the statement wrong or is there a better way of doing it? Ideally, I'm working towards showing tickets great than X but less than Y but if the greater than doesn't work as expected there's no point proceeding.
We may need to gather more information about your metric/query for us to identify what the calculation is behaving that way. I'll go ahead and create a private ticket for this.
Thanks Dominic!