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.
Please sign in to leave a comment.