Filter in subquery
Answered
Hello everybody,
I have a trouble because i dont achive my filter works in the subquery, i do a union in my report and add a filter calledGOBMX filter but this filter does not work, because the query give me 5,000 rows, when only with the filter should give 365 rows. The filter is a calculated field.
Hi Jesus,
Thanks for reaching out. Without knowing your data and actual filter setup it's simply not possible to say what's occurring here. You've provided a screenshot of the field being in the report, but can you provide the actual calculation and filter settings? It seems unlikely this would be defective behavior - a filter not providing expected values typically comes down to report setup and/or the data itself.
Regards,
Mike
Hi Jesus,
Thanks for reaching out. Without knowing your data and actual filter setup it's simply not possible to say what's occurring here. You've provided a screenshot of the field being in the report, but can you provide the actual calculation and filter settings? It seems unlikely this would be defective behavior - a filter not providing expected values typically comes down to report setup and/or the data itself.
Regards,
Mike
Hi Jesus,
I just wanted to check in and see how things are going with this.
Regards,
Mike
Hi Jesus,
I just wanted to check in and see how things are going with this.
Regards,
Mike
Hi Jesus,
I'm going to go ahead and mark this one as Answered since I haven't heard back from you, but if you have further questions or concerns on this, if you respond, it will re-open the case and put it back in my queue and I'll be happy to help.
Regards,
Mike
Hi Jesus,
I'm going to go ahead and mark this one as Answered since I haven't heard back from you, but if you have further questions or concerns on this, if you respond, it will re-open the case and put it back in my queue and I'll be happy to help.
Regards,
Mike
Replies have been locked on this page!