You’re offline. This is a read only version of the page.
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
Hi All,
Issue solved.
Thank you.
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.
Thank you.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (