Announcements
No record found.
Hi,
I'm having an error in report Writer (Illegal Syntax) when I tried to use function RW_Strip for Global - Functional Currency.
Is there anything wrong in this?
Thank you.
*This post is locked for comments
So, are you saying you are trying to strip blank spaces out of the global Functional Currency variable? For example, if your Functional Currency is expressed, i.e., as "Z - US $", you want the result returned to be "Z-US$". If this is the case then RW_Strip should work.
1. In the Calculated Field Definition window, enter a name for your calculated field
2. Set the Result Type to String and the Expression Type to Calculated
3. From the Functions tab, select User-Defined. In the Function drop-down, locate RW_Strip, then click Add
4. Click on the Fields tab, from the Resources drop-down select Globals. From the Field drop down, choose Functional Currency
5. Click on the Constants tab. From the Type drop-down, select String. In the Constant field, press the space bar on your keyboard, then click Add.
This completes the expression. Do not attempt to insert any spaces manually between the parenthesis or try to insert parenthesis on your own. Report Writer will do this as you build the expression.
Hi Mariano,
Thank you for your reply.
Instead of using a Functional Currency, I've create another calculated field to be used in this function. And it works.
Another problem is, currently I'm using this function to add bracket in between functional currency. Eg: (USD). But it only show '(USD'. Closing bracket is missing. I've made width of the field long enough but it still didn't show.
Hi All,
Issue solved.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
