Is there a way to format the output of properties on an event handler - notify? For example I do not want decimals to show in an email with 8 decimal places.
You can use ROUND(V(YourVariable),0). The 0 represents how many decimal places to display.
Thank you! What about when it puts the N' in front of some properties? I've noticed that if I use P instead of FP or V instead of FV it seems to get rid of that, but does it change the functionality at all?
You're seeing an N' as part of the variable/parameter value in AES? That's strange, N' is usually used for SQL queries to write data. I have never seen it as part of data retrieval. Are you on premise? Does the N' exist as the table value?
Is there a way to format into a currency to have commas in the numbers where appropriate?
In AES variables are mostly evaluated as strings (CAST the retrieved Property as String if you need to be sure) and you can use the REPLACE function e.g
REPLACE(<string>, ".",",")
likewise you should be able to replace N' with an empty string:
REPLACE(<string>, "N'", "")
Alternatively since you know the Purchase Req number is always 10 characters long, use the RIGHT function.
I know this is an old topic, but ReesH2, would you be able to provide an example of the syntax? Let's say I need to provide the output in currency format for a Credit Limit (which I do.)
My current input is ROUND(V(CreditLimit),2)
How would I change that in my notify body to make it express with commas?
Can you just clarify. When you say "express with commas" are you meaning thousands separators? Or are you trying to replicate the full Input Mask capability built into IDO Properties?
