cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Money formatting

heidi_andrew
Contributor

I am multiplying a salary field by 100. Any salary with a decimal point is still showing the decimal afterwards even tho in the mapper snap, it looks correct. Here is my code in mapper snap: ($RATE_1*100).
It is showing correctly in mapper snap but when it shows after the fixed format operation, it has the decimal.
image

Here is the final output:
image

I tried to use the autoprep but the format i need did not show. Can you point me to some doc on this kind of formatting expression?

1 ACCEPTED SOLUTION

pmancevski
New Contributor III

Hi,

If you already did your calculation you can try with: parseInt($RATE_1*100).
Also check Math functions and properties.

Check following links:
Global Functions and Properties
Math Functions and Properties
Number Functions and Properties

Thanks,
Pero M.

View solution in original post

2 REPLIES 2

pmancevski
New Contributor III

Hi,

If you already did your calculation you can try with: parseInt($RATE_1*100).
Also check Math functions and properties.

Check following links:
Global Functions and Properties
Math Functions and Properties
Number Functions and Properties

Thanks,
Pero M.

heidi_andrew
Contributor

in autoprep i used the integer format. then in mapper i used your parseInt($RATE_1*100) and it worked just like it should. Thank you.