Skip to main content

Hello,

I hope this message finds you well.

I am currently facing an issue with Business Reporter and would appreciate your assistance. I am trying to filter accounts that start with ‘6’ and ‘7’. As shown in the attached screenshot, I added a "LIKE" condition in the filter criteria. However, I received an error message indicating that the syntax is incorrect.

Additionally, it seems I cannot add multiple rows to define separate filters for each condition.

If there is an alternative solution to achieve this filtering, I would be grateful if you could share it with me.

Thank you in advance for your help!

Best regards,
Karim

 

Hi,

You cannot use asteriks (*). You must use percentage (%).

Try entering BETWEEN ‘6%’ AND ‘7%’

Or go to advanced filtering and use the following 

(DIM_ACCOUNT.CODE LIKE '6%' OR DIM_ACCOUNT.CODE LIKE '7%’) AND
DIM_CODE_D.CODE IS NOT NULL AND
DIM_COMPANY.CODE = &Company

 

Hope this helps

Hi ,

Thank you for your suggestion. I’ve tried using BETWEEN '6%' AND '7%', but unfortunately, it doesn’t seem to return the expected results any ‘6%’.

Additionally, when I use LIKE, it results in an error message. Could you please clarify if there are any additional settings or steps I might need to adjust?

Looking forward to your guidance.

Best regards,
Karim

 

Hi again,

I think better option is to use advanced parameter with the code I shared. Because when you enter parameter BETWEEN ‘6%’ AND ‘7%’, it will return you anything start with 6 until anything start with 7. But it will not show you result any account starting with say 71 etc.

Either change parameter to BETWEEN ‘6%’ AND ‘8%’ so it will cover range of 7 accounts. Or use the advanced filtering.

Hope this helps

Reply


Terms & ConditionsCookie settings