Mapping Issue number format

[vishnu_pallamreddy]

Hi All,

Our issue is if amount is 4500 then we want 45.00

or 500 then we want 5.00

if amount 50 we want 0.5

if amount is 50000 then 500.00

is it pissible in graphical mapping?

Please give me a good suggestion?

Thanks in Advance,

vishnu p.

[Former Member · Accepted solution]

Hi,

Use Divide by function followed by format num...(mention here format as .00)

only thing here will be decimal numbers will be followed by number of zeros you mention...

e.g. 50 will be 0.50 insead of 0.5.. and hope that should not be a problem

HTH

Rajesh

[vishnu_pallamreddy · Accepted solution]

Thank You Rajesh

[vishnu_pallamreddy · Accepted solution]

hi Rajesh,

if we pass spaces in that amount mapping shows error.

what is the problem?

Thanks in advance,

vishnu

[anand_shankar10 · Accepted solution]

In real time, you wont be getting any space but a blank value. In that case you can use "MapWithDefault" just after the source value and put "0" in this. This will solve your issue.

But still if you are sure that you can get a space you can go ahead with using "IfElseThen" using condition that If the source value == " " (space) then Pass a constant "0" Else use the Source Value.

Thanks

Anand

[vishnu_pallamreddy · Accepted solution]

Thank you Anand,