Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
BI Publisher - RTF template - write a numeric value in letters — Cloud Customer Connect
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

BI Publisher - RTF template - write a numeric value in letters

Accepted answer
27
Views
12
Comments
edited Sep 18, 2020 8:55AM in Reporting and Analytics for HCM 12 comments

Summary

Need to write in letters a numeric value from a BIP field

Content

Hello,

I am creating a RTF template that I want to display as a report in BI Publisher.

In this RTF, I'd like to put the salary of an employee, but written in letters ("three thousands and fifty euros" instead of "3050 euros").

I know there is a formula that does that in Word when adding a Word field with Alt+F9. For example, {=10\*cardtext} would display "ten".

However, I haven't managed to do that with a HCM field (Salary amount) as value to write in letter.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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