You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to translate amount into words

in Assets 1 comment

Summary:

(1) In Fusion BIP Report, how to translate the USD amount into English words?

for example, 0.11 needs to translated as 'Zero and eleven USD'.

I have tried tried using the below function in RTF template, it works fine in preview, but not working in BIP bursting. After bursting, it shows 'Null elf USD'.
<?xdofx:to_check_number(round(GRAND_TOTAL_AMT,2), 'USD', 'CASE_INIT_CAP', 'DECIMAL_STYLE_WORDS') || ' USD'?>

(2) In Fusion BIP Report, how to translate Thailand amount into Thai language words?

Content (please ensure you mask any confidential information):

In R12, we can use database function, but in Fusion we don't have access to database, and the data set does not allow to define function and call this function in the sql query, what should we do?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!